Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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().