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?