How to ensure that export order is matching with creation or selection order?

1

Hello Team,

One of our usecase while run time user will select either of the type (Order_W or Order_NW) from multiple drop downlist & Fill the corresponding text box. The selection order completly random example.

First time may be

Order_W1
Order_W2
Order_NW1
Order_W3
Order_NW2
Order_NW3

Second Time:

Order_W1
Order_NW1
Order_W2
Order_NW2
Order_W3
Order_W4

Third Time:

Order_NW1
Order_W1
Order_NW2
Order_W2
Order_NW3
Order_W3

I have captured this selection order as below [{count:1, task_name:“Sample_Task_1”, Order_W:1},{count:2, task_name:“TTT_Task_2”,Order_NW:1},{count:3, task_name:“Sample_Task_3”,Order_W:2},{count:4, task_name:“SSS_Task_4”,Order_NW:2},{count:5, task_name:“Sample_Task_5”,Order_W:3},{count:6, task_name:“CCC_Task_6”,Order_NW:3},{count:7, task_name:“Cost_Task_7”,Order_W:4}]

But my export log order always as below in excel sheet.

Order_W1
Order_W2
Order_W3
Order_W4
.
.
Order_NW1
Order_NW2
Order_NW3
.
.
.

Now I want to compare my export order in the excel is correct or not. Do you have any suggestion?

Example user selected Order_W1,Order_NW1,Order_W2

When I compare with excel row order

Order_W1
Order_W2
Order_NW1 then result should pass

But export order is

Order_W2
Order_W1
Order_NW1 then result should fail

2

Hey Thanagaraj,
Can you share the code that you are using to import and export the data?
Cheers,
Karsten

3

Hello Karsten,

Thanks.
The issue was resolved as below steps.

  1. Check the insert type
  2. Based on type insert into either Order_W or Order_NW list
  3. Now merge the list ( so we will get the required order)
  4. Now compare with excel export order.
1 Like