Hi I have a ReviewDocuments CDT which contains two multi value child CDTs.

suem over 8 years ago

Hi
I have a ReviewDocuments CDT which contains two multi value child CDTs.
I have a documents array containing 2 documents and a CDT FieldworkAnalyticalReview array with 3 sets of details.
Each FieldworkAnalyticalReview needs to be associated with each of the documents
i.e.
Documents: {A,B}
FieldworkAnalyticalReviews: {1,2,3}
Which needs to become :
1.          ReviewDocuments CDT ID=1 with 1A
2.          ReviewDocuments CDT ID=2 with 1B
3.          ReviewDocuments CDT ID=3 with 2A
4.          ReviewDocuments CDT ID=4 with 2B
5.          ReviewDocuments CDT ID=5 with 3A
6.          ReviewDocuments CDT ID=6 with 3B

What would be the best way to achieve this.
Thanks

Discussion posts and replies are publicly visible

Parents

0 suem over 8 years ago

Hi all, I’m afraid we’ve had to re-work our output CDT to match others in the system so it’s been simplified to the following:
ReviewDocument :-

The two input CDTs, Documents and Reviews:-

For each combination of Review and Document we need to write a ReviewDocument.
For example if we have 3 rows in Review {“A”,”B”,”C”} and two in Document {1,2} then the output ReviewDocument will contain 6 rows ie A1, A2, B1, B2, C1, C2 where ReviewDocument .farId = gtFieldworkAnalyticalReview.id and ReviewDocument .assignmentDocumentId = gtassignmentDocument.appianDocumentID

So far we have had little success in nesting the functions and have yet to discover the correct combination which seem endless -
single rule in a script task output, or via the script task inputs or possible using an MNI?
thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 suem over 8 years ago

Hi all, I’m afraid we’ve had to re-work our output CDT to match others in the system so it’s been simplified to the following:
ReviewDocument :-

The two input CDTs, Documents and Reviews:-

For each combination of Review and Document we need to write a ReviewDocument.
For example if we have 3 rows in Review {“A”,”B”,”C”} and two in Document {1,2} then the output ReviewDocument will contain 6 rows ie A1, A2, B1, B2, C1, C2 where ReviewDocument .farId = gtFieldworkAnalyticalReview.id and ReviewDocument .assignmentDocumentId = gtassignmentDocument.appianDocumentID

So far we have had little success in nesting the functions and have yet to discover the correct combination which seem endless -
single rule in a script task output, or via the script task inputs or possible using an MNI?
thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data