Fetch details in Interface from database

Question

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.

Mike Schmitt · Answer

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.

Ashwin · Answer

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

GauravSingh · Answer

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.htm l