QueryDef operation from JSSP not functioning | Community
Skip to main content
Level 6
Mar 19, 2022 7:10 PM UTC
Solved

QueryDef operation from JSSP not functioning

Hello Folks,

Hope you're doing well

I have a strange and weird situation where I am doing a simple select operation using queryDef on a schema from JSSP. When I hit the JSSP in browser I am expecting the record details as response, however I am getting an empty collection even though data is present in DB. I tried other operations like count, getIfExists and get. When I tried get I got below error.

Same queryDef with any given operation works absolutely fine when executed from a JavaScript activity within workflow. I am not able to understand where it is going wrong. With your expertise, please help on how can we resolve this.

Thanks,

SSB

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SurabattulaSrAccepted solution
Level 6
Mar 25, 2022 5:11 PM UTC

This is resolved now.

There was a sysFilter condition added in schema which is restricting access to data operations only to a certain named rights.

5 replies

SurabattulaSrAuthorAccepted solution
Level 6
Mar 25, 2022 5:11 PM UTC

This is resolved now.

There was a sysFilter condition added in schema which is restricting access to data operations only to a certain named rights.

Translate
_Manoj_Kumar_
New Participant
Mar 20, 2022 10:23 PM UTC

Hello @surabattulasr 

 

Try changing the condition in where statement to [folder/@id]

If that does not work. Please share the query here.

 

 

Translate
     Manoj     Find me on LinkedIn
Marcel_Szimonisz
New Participant
Mar 21, 2022 12:54 PM UTC

Also 1=0 does not make sense here

Translate
Level 6
Mar 25, 2022 5:14 PM UTC

1=0 an additional condition I suspect is because of that sysFilter

Translate