I am trying to fetch details in Interface for displaying purpose from database. I don't know where am missing something. If someone can help. I have called the CDT as RI.
a!textField( label: "Address", labelPosition: "JUSTIFIED", value: ri!CompanyInformation.Address, saveInto: {}, refreshAfter: "UNFOCUS", readonly: true, validations: {} ), a!textField( label: "Website", labelPosition: "JUSTIFIED", value: ri!CompanyInformation.Website, saveInto: {}, refreshAfter: "UNFOCUS", readonly: true, validations: {}
Note: I have data in database.
Discussion posts and replies are publicly visible
I can't really tell what you've tried, but you need to query the data from the database within Appian before you can display it on a form. If the form is to be used in a process model, a typical way to do this is to query the data into a Process Variable and then pass that information into the interface as a Rule Input (ri!) variable. Another way would be to query the data directly on your form, into a local variable. It all depends on what you're trying to do.
In your RI you have mapped a CDT so you need to i=enter values into RI to show the values on form
else you can use expression rule to fetch the data from DB and use that rule into interface and call that in a local variable and then print it
example:-
load(
local!data: rule!name if the expression rule
a!textField(label: "Address",labelPosition: "JUSTIFIED",value: localdata.Address,saveInto: localdata.Address,,refreshAfter: "UNFOCUS",readonly: true,validations: {}),
)
try this
Just have a look on these topics you will get to know how u can fetch data from DB and store it in a localVariable. And then using that local variable u can display the data in grid.
https://docs.appian.com/suite/help/19.1/Query_Recipes.html
https://docs.appian.com/suite/help/19.1/Grid_Tutorial.html
Thanks
What is the error? You need to provide the error or the output in order for us to visualize what the problem is.