Hi team,I need help regarding to the Fetching the DB table names into Appian INV, using the table name,Example: i have table name called Students in DB if i select that name in Appian Interface I need to display that Students table details in InterfaceIs it possible or not if it's possible could anyone help me with it how we can do it
Discussion posts and replies are publicly visible
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
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.