Fetch Db tables into Appian Interface

Hi vempatir680997 , Yes, we can display the details in the interface. First, we need to create a record or CDT to connect with the table and retrieve the data into Appian. Later, we can fetch the data using a!queryRecordType() or a!queryEntity() or by creating a grid, or we can customize the interface based on the requirements or design.

Hello vempatir680997  Do you have records for all these tables? Have you created any stored procedures for doing this? How are you planning to select the DB Name. Also how many tables do you have or plan to show on selection in the interface?

No i don't have records for all but it should be dynamic with the name of the table i want to fetch the table into Appian interface,
if i created new table in DB and after if i call that table name into appian interface so i need that table name and i have 8 tables currently in DB

Hi gayatria0439 ,

In your scenario i have to create the Records or CDT's in Appian but i don't want to create those in appian,
if i want to create those record and CDT's it should be dynamic only,
example: if a new table added in DB after if i select the same name in Appian that table will display with out creating the record or interface if we have to create record or CDT it should be dynamic only.

If you want to fetch the details to display in the Appian interface, we first need to connect to the database using a CDT or Records.

yes, but i have to get this dynamically like if we have to create the records or CDT's it should be atomically create and display the data in interface level.

You can try using stored procedure and run the SP based on the provided selection.