+6Hello all,
i have a question regarding my table order after a manual file upload. Everytime I upload my table, the table is reversed according it's case number. All activities are then ordered from last (top) to first(bottom) in each respective case. The table is also ordered according to Case IDs in general.
Here is an easy example of what I am experiencing:
Thanks in advance
Fynn
+4Hi Fynn,
Is this a problem ?
You can easily run a order by query and get the data sorted according to the timestamp or case.
In any case once you have the data in the analysis you will see it according to the case id and timestamp.
Not sure if I understand the question well here.
+6Hi Fynn,
Is this a problem ?
You can easily run a order by query and get the data sorted according to the timestamp or case.
In any case once you have the data in the analysis you will see it according to the case id and timestamp.
Not sure if I understand the question well here.
Yes, the problem is, that sometimes the timestamps are equal (i forgot to add this to the example). This is why I also added a RecordID column to the table, that functions as the sorting column.
Since the table is reversed after the upload, the RecordID also numbers the rows in reverse. So that the last activity, for example, receives RecordID 1 and the first activity in a case receives RecordID 5.
I hope this helped to understand my question.
+4Yes, the problem is, that sometimes the timestamps are equal (i forgot to add this to the example). This is why I also added a RecordID column to the table, that functions as the sorting column.
Since the table is reversed after the upload, the RecordID also numbers the rows in reverse. So that the last activity, for example, receives RecordID 1 and the first activity in a case receives RecordID 5.
I hope this helped to understand my question.
If you are adding an sorting then it should take care of the problem while displaying the process explorer. I am still a little confused with the question, however can you try creating the process explorer and see if that is still causing the problem
Are you assigning the sorting while making the activity table ?
+6Yes, the problem is, that sometimes the timestamps are equal (i forgot to add this to the example). This is why I also added a RecordID column to the table, that functions as the sorting column.
Since the table is reversed after the upload, the RecordID also numbers the rows in reverse. So that the last activity, for example, receives RecordID 1 and the first activity in a case receives RecordID 5.
I hope this helped to understand my question.
I am currently working on it. If I find a good solution I will come back to you.
Thank you Abhishek!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
