Hi All, Could anyone please let me know what could be the reasons for failure of

sikhivahans over 10 years ago

Hi All, Could anyone please let me know what could be the reasons for failure of executequery() function? I have provided the datasource (checked in the custom.properties) as well as the query correctly but it's not retrieving any results. But it is working fine in case of Primary DS i.e. which contains Appian-specific info. When I tested the same function on another server instance its working fine in case of Primary as well as Business DS....

Discussion posts and replies are publicly visible

0 akhilan over 10 years ago

Can you elaborate what you mean by failure? Is any exception being thrown? Does the same query work if tried using a query rule or query db smart service?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 years ago

Hi akhilan, I wasn't at the desk today. Failure in the sense, an empty array is returned. No exception is thrown. Yes, the same query is working fine with query rule as well as querydb
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rickyc over 10 years ago

I am also facing the same issue. The same executequery() is working fine in script Task node but not with expression rule... please help! Thank you in advance :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel