Hi Team,
I have a database query collection wherein I have formed a unique values based on Recipient and approval state (UID_PersonOrdered+UID_CCC_WorkflowRule) in the selection in order to create a collection data view. So I have created a new collection (collection data view) making the unique value from the database query collection as the primary key for listing the pending request records by Recipient and Workflow state based.
I tried with Container iteration for that particular column to fetch distinct shopping cart IDs, but it is not working when traversing between pending request page and approval page
Is it possible to use function to fetch all distinct records from another database query collection based on the unique value (the primary key) from current collection (collection data view), however I tried using function as well, but it seems it is working with one value as result, After I changed the the value type to 'Value list', I receive the compile error stating ' Error code: CS0029; Error description: CCC_ITShop_Approvals.cs(6945,28): Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<string>' to 'string' (CS0029)
The version of the tool is V8.1
Best regards,
Prakash