QueryDef operation from JSSP not functioning | Adobe Higher Education
Skip to main content
S
SurabattulaSr
Level 6
March 19, 2022
Besvarat

QueryDef operation from JSSP not functioning

  • March 19, 2022
  • 2 svar
  • 1565 visningar

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

Det här ämnet har stängts för svar.
Bästa svar av SurabattulaSr

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.

2 svar

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
March 20, 2022

Hello @surabattulasr 

 

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

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

 

 

Manoj  | https://themartech.pro
Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor
Community Advisor
March 21, 2022

Also 1=0 does not make sense here

S
SurabattulaSrSkribent
Level 6
March 25, 2022

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

S
SurabattulaSrSkribentSvar
Level 6
March 25, 2022

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.

    Villkor och bestämmelserAccessibility statement

    Loading footer...