Scripts - Queries

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()

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()