I am facing issue in apian, as I need to get the data which is present in cloud data base store to my appian process modeler in CDT form of every data, how to do that could you suggest your ideas on it
mainly i need to get the data which is present in cloud data store to into my appain ui inteface . every data which is present in cloud data store (table) need to come one by one in array form .
Discussion posts and replies are publicly visible
Hi, we can create a query rule to get the data from the database https://docs.appian.com/suite/help/22.3/fnc_system_a_queryentity.html.
And we can use that rule inside a script task to get the data and save it into your process variable https://docs.appian.com/suite/help/22.3/Configuring_the_Script_Task.html.
To display the data on the interface you can use the readOnly grid.
yes , i am getting data in script task but i need data in CDT format in my process model , i means with that data i need to perform one operation on it. and i need to get in arry format ( table which present in cloud data). so if u how to write code in script task or expression rule could you send plz
Hi we just have to create the process variable of CDT fromat you want with multiple as true and you can use the update function to update the data.
ohhh! that ook but i am getting all the data in paragraph wise not i am not getting data like which is in cloud as s indivisually , can we connect through chat . if possible if ur from india
Yes sure we can, but getting the data in paragraph any specific reason for that?
You can wrap cast() function around your query entity and cast it to your CDT array. Attaching a screenshot below for your reference,