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
Discussion posts and replies are publicly visible
Hi
Is there a reason for not using queryEntity?
Agreed - this is a pretty straightforward query that can easily be done using a!queryEntity(). I highly recommend only using the Query Database node when you have extremely complex SQL. The Query Database node doesn't return the data as a CDT, which makes it more difficult to work with in a process. Plus, you can use a!queryEntity() in any expression, while the Query Database Smart Service only works in a process model.
hi,
I don't want to open new question but I have same problem.
I need to provide in criteria dynamically but I get no results. There is no error and no data. In data section the in criteria are definded as :
="'abc1', 'ddddd33333'"
part of sql:
and c.userid in ( ac!sqlMailboxes )
full sql:
select c.userid as Milbox, cast(a.Creationtime as date) as RFDate,count(a.uniqueid) as NoOfFaxesfrom users cjoin documents aon c.handle = a.owneridwhere c.userid in ( ac!sqlMailboxes )group by c.userid, cast(a.Creationtime as date)
Same query run on SQL Server return data.
How to deliver this in criteria based on string array variable ?
Really the same question applies here. This is a simple query - can you use a!queryEntity() or a!queryRecordType() instead of the Query Database Node? Those functions are much easier to work with and should support the query you suggested.
I would create a view in DB and query it using queryEntity().