Cloud database - select SQL with some condition in 5+ tables to run in Expression rule

I cannot follow. Yes, you can query data using Appian functions. You can add conditions and aggregations. When you explain in more detail what you want to achieve, I am sure we can help.

Thanks Stefan, for your reply. let assume I'm currently queried data using sql and takes the one of the columns and adding into my custom unnamed rule input. Problem is that its take more time. 

If its possible to queries the data using same sql statement as one of the parameters that will save my time

eg: 

a!localvariables(
local!result,
a!queryRecord(
sql: "SELECT id FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id JOIN table3 t3 ON t2.id = t3.id JOIN table4 t4 ON t3.id = t4.id JOIN table5 t5 ON t4.id = t5.id WHERE t1.column1 = :value1 AND t2.column2 = :value2",
parameters: a!queryRecordParameters(
value1: "some value",
value2: "another value"
),
fetchSize: -1
)
);

so i assume if that local!result contains the same id which i runed in sql that will helps me

Thanks Stefan, for your reply. let assume I'm currently queried data using sql and takes the one of the columns and adding into my custom unnamed rule input. Problem is that its take more time. 

If its possible to queries the data using same sql statement as one of the parameters that will save my time

eg: 

a!localvariables(
local!result,
a!queryRecord(
sql: "SELECT id FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id JOIN table3 t3 ON t2.id = t3.id JOIN table4 t4 ON t3.id = t4.id JOIN table5 t5 ON t4.id = t5.id WHERE t1.column1 = :value1 AND t2.column2 = :value2",
parameters: a!queryRecordParameters(
value1: "some value",
value2: "another value"
),
fetchSize: -1
)
);

so i assume if that local!result contains the same id which i runed in sql that will helps me

You cannot run SQL code in Appian. Technically you can using the Query Database node, but I do not recommend that.

What do you mean with "Problem is that its take more time. "?

Do you want to implement a specific query, or try to understand how to query a database in Appian in general?

Thanks for update. 

Do you want to implement a specific query, or try to understand how to query a database in Appian in general?  - Yes, in terms of 1000+ rows while using the same in each foreach its takes more time to execute and copy and paste row id also takes more items so, i tried to use this kind of approach but i think direct SQL will not support in Appian Expression rule

The query you defined above can absolutely be configured in Appian without writing SQL. I'd recommend looking at the query recipes to see some examples: docs.appian.com/.../Query_Recipes.html

I still have a hard time understanding the purpose of this. What do you want to achieve?

Thanks for reply @Peter Lewis, if im using multiple recordType in single rule and usage of 5000+ array rule input at same time will consume more memory and there will more delay right eg: 20,000+ ms until the query exectuion?

I saw you are trying to perform a join on multiple tables. So either create a record and establish the relationship between these tables or create a database view with your SQL statements and then query data into Appian. Hope it helps.

Thanks , can you share any documentation link for this if possible, i will try the same and let you know if its works for my case

1. Record Type Relationships

2. Query Recipes

Appian is not meant to perform such high volume data transactions. I suggest to write a stored procedure in the database.