Loop through records in a View Ax 2012 R2( Need a job to achieve this)
I have a viewA where i have three fields
Destination , Source, FieldX
I have a table where i have master list for Source
This table contains S1, S2…
In the view for each S1 i need to find the final Destination Value
Example:
Destination Source Type
D1 S1
D2 D1
D2 No record found
Explanation for above example: I took S1 from master list and placed in Source field in View.
then I read Destination value for that Record which is D1. Now I placed D1 in the source field filter
and i found a record with destination value D2. Now i took D2 and i placed
it in the source field filter and i didnt find a record. i stop the loop here and i had
to save D2 value.
For S1 , the final Destination value is D2.
Example 2:
Destination Source Type
da s2
db da
dc db
dc No record found
For S2, the final Destination value is Dc.
I am not sure how i should loop in view for S1 to find the D2.
I had to do this process one by one for all S1,s2…Sn.
I tried few things using while/for or other loops with no luck.
Can someone help me with a base code to acheive this?