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
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?
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/.../