Hi Team,
Is there a direct to execute the SQL scripts directly in Appian instead of executing in DB?
Discussion posts and replies are publicly visible
Hi Purvaja,
Could you please share the scenario?
What do you want to achieve?
Thanks for the reply.
To be clear, a sample query something like this.
SELECT * FROM `lam_leaves` WHERE leave_type_id in (SELECT leave_type_id from lam_leave_type) GROUP BY from_date;
How complex query we can directly use in Appian. generally approach is we are using SP to query and store it in temp table and then capture the result from it.
Did you try to use the latest data fabric features? Synced records and record relationships?
You can use Query Database Smart service
docs.appian.com/.../Query_Database_Smart_Service.html
Purvaja said:How complex query we can directly use in Appian. generally approach is we are using SP to query and store it in temp table and then capture the result from it.
For querying purposes, I don't think that we need to store it in a temp table instead we can use a!executeStoredProcedureForQuery()
A direct answer is no.
Appian will not accept SQL code for execution.
There are many alternatives. Your example could easily be handled using the relationship features of RecordTypes, on the Appian side. But if you really need to approach the problem from the Database side, you may want to consider implementing a VIEW.
mariadb.com/.../
Another way to do it is to use the new JDBC connected system (available in 23.2)
docs.appian.com/.../custom-jdbc-connected-system.html