Hi everyone i am new at Appian and i m trying to understand how i display the labels and the choice values that comes from a DB . into a dropdown and save it in a rule input after
its throwing an error that i dont understand.
can someone explain what is my error and what is the better solution for doing this ?
thank your
Discussion posts and replies are publicly visible
and this is how i call the rule expressinon in my localvaraible
The value AND data type of the parameters value and choicevalues must match. I assume that you want to store the ID of the selected sector and customer.Sector_Activity is an integer. Then
choiceValues: local!query_data_activity_sector.ID
should work.
BTW, your variable naming seems to not match the Appian best practices,
docs.appian.com/.../Standard_Object_Names.html
i forgot to specify that customer is CDT and sector activity is also a CDT and i want to save all the values in the Sector_activity . When i m doing what you said it is throwing an error about the casting . how we doing the cast ? and for what reason i need to cast it ?
Can you show me a screenshot of the customer CDT?
this is the customer CDT
This is a tricky issue to troubleshoot - I believe what's happening is that there is a type mismatch between your choiceValues and your saved value. The choiceValues are of type dictionary (because that is what is returned by a!queryEntity()), but the value is of type Sector_Activity. For a dropdown field to work, the types and values must exactly match.
It actually looks to met that you're pretty close with yoru commented out code - if you run the cast you already have there against your query result, it should cast correctly and it should eliminate the type mismatch.
i solved the problem , now it is working
i had to do cast my result from the query entity (because it s returning a dictionary of CDT ) as you say , so i did a casting to a list of my CDT.
like in the picture , now i can display the content and save it in the rule input.
Since your Sector_Activity in nested within Customer Cdt, and your choice values are integer id's, you should update you value and saveinto to append .id, like:
ri!customer.Sector_Activity.id
assuming, id is the field in Sector_Activity where you wanna store your selection value