Skip to main content

8 replies

nitishr0002
nitishr0002
Participating Frequently
Oct 12, 2023 10:05 AM UTC

Cross validate the data with the structure of the entity. Sometimes the data queried could not be as per the data type or they might overflow with the length set.

harshitb6843
harshitb6843
Brainy
Oct 12, 2023 10:07 AM UTC

Its fine. You can still proceed. To solve this error, just add sort info on the primary key of the column and it should be gone. I have faced it multiple times but couldn't understand the reason. 

mudasirb0001Author
Participating Frequently
Oct 12, 2023 10:16 AM UTC

but it's not allowing me to add sorting as long as I select constant it give me error 

harshitb6843
harshitb6843
Brainy
Oct 12, 2023 10:22 AM UTC

Then you can avoid using the builder and directly write the code the expression. 

stefanhelzle0001
stefanhelzle0001
Brainy
Oct 12, 2023 10:49 AM UTC

Did you check the tomcat log file for any details?

mudasirb0001Author
Participating Frequently
Oct 12, 2023 11:25 AM UTC


a!queryEntity(
  entity: cons!DATA_STORE_CONSTANT,
  query: a!query(
    logicalExpression: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: "coveragesiteid",
          operator: "=",
          value: ""
          /*with and without value giving same error*/
        )
      },
      ignoreFiltersWithEmptyValues: true
    ),
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 2000,
      sort: a!sortInfo(
        field: "siteid_Pk",
        ascending: true
      )
    )
  )
)

Terms & ConditionsAccessibility statement