Query Database

Question

Hi, 
 
 I am trying to run this querry in query database but getting an error: 
 
 SELECT ID,PRIORITY,CREATION,DURATION,FIRM_GROUP,IS_SCHEDULED,STATUS FROM XYZ_VIEW WHERE IS_TEMP=1 AND STATUS NOT IN ('Closed', 'Complete', 'Cancelled') AND IS_SCHEDULED = 1 ; 
 
 Error:

TIA

ankitab0001 · Answer

Hi apoorvam 
 Please remove the semi- colon at the end of the query statement. 
 
 Thanks

Mike Schmitt · Answer

It's super easy to create a View to do the Join you need, with accompanying CDT / data store entity, and then query that. This is super standard practice. And in 21.2+ you also have the option to use record type relationships. Either of these approaches will be much easier than trying to deal with directly using SQL in a process.

Chris · Answer

First, I agree with the other suggestions in the thread regarding creating a view for your query, attach a CDT to it (only need one) and utilize a!queryEntity() to retrieve data. 
 However, if for some reason it is required to use a Query DB node, the way we used to do this in legacy versions of Appian was to use INSTR (Oracle) or CHARINDEX (MSSQL) such as the example I posted in this thread .

Query Database

Top Replies