QueryDef operation from JSSP not functioning

[Ssb_94]

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

[_Manoj_Kumar_]

Hello @Ssb_94 

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

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

[Marcel_Szimonisz]

Also 1=0 does not make sense here

[Ssb_94]

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

[Ssb_94]

Thanks @_Manoj_Kumar_ 

[Ssb_94 · Accepted solution]

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.