Hi team
I want to access values in a dictionary without using a loop, because in real-time we have 440 rows, and each row has 150 columns. Running a loop over each row to get values is causing performance issues.
I checked the Appian Community and found that we can use the a!keys() function to extract all keys
a!keys()
Id (PK), PartNumber, Status, Country_1, Country_2, Country_3, ..., Country_150We are using CDT to get data from DB so output of CDT in dictionary format.Expected output:
Id (PK), PartNumber, Status, Country_1, Country_2, Country_3, ..., Country_150We are using CDT to get data from DB so output of CDT in dictionary format.
Discussion posts and replies are publicly visible
Hi Goddati Venkatesh I am aware you have a solution now yet I feel I couldn’t understand your usecase properly the other day and suggested to alter your existing view as solution. Though now I think a view is not needed /appropriate for your use case at all.
Instead of a view you can query country column from the child table by request id within Appian expression rule so that the output you receive (the country names) will be a list of strings. In your main rule where you are creating this dictionary with the countries, you can use the function joinarray() with separator as comma(,) like below.
joinarray(local!listOfCountries,”,”)
Here you need to replace the variable to variable that contains list of countries for given request id after querying data/ the expression rule that returns countries from child table.
This doesn’t require a view and using a!foreach() you can get the expected output for each request id.
Harsha Sharma Thank you for your time,
The approach you're suggesting also works without using a nested for loop. However, we still need to call the child record inside the outer loop.For example, if the number of rows is 440, then we would need to call the child record 440 times. This could lead to performance issues, especially since we can't load all child data at once, we have around 28,000 rows, and the record limit is 5,000.Therefore, calling the record in each iteration of the outer loop becomes mandatory, which might impact performance.
for