-
Type:
Bug
-
Resolution: Fixed
-
Priority:
High
-
Component/s: Assets - AQL
-
2
-
Minor
-
Warranty
Issue Summary
Trying to Bulk Edit objects from the UI when Advanced AQL filter contains like EMPTY e.g.
"Example Text 1" LIKE "EMPTY" AND "Example Text 2" IS EMPTY
results in "An unknown error occurred" message.
Steps to Reproduce
1) Make sure that under your Schema Tree you have an object with at least two attributes with Type Default and Type value Text defined. For further reference lets call this fields: "Example Text 1" and "Example Text 2".
2) Make sure to fill out one of the text attributes of a couple of objects with the following string: "EMPTY" (write it without the quotes)
3) Go to the Objects view in the UI and filter using the following Advanced AQL:
"Example Text 1" LIKE "EMPTY" AND "Example Text 2" IS EMPTY
4) Notice that if you try to edit the Advanced AQL filter you'll notice that the quotes characters are removed from the like "EMPTY" part of the AQL:
"Example Text 1" LIKE EMPTY AND "Example Text 2" IS EMPTY
(see JSDCLOUD-16343 for more details).
5) Click on the Bulk edit objects and try to change the value of any of the Text attributes to anything. E.g. "test" (write it without the quotes)
6). Click on Save and you'll see an error message pop up: An unknown error occurred
![]()
Expected Results
You're able to edit the objects successfully.
Actual Results
The below exception error is shown in the UI:
An unknown error occurred
Workaround
Avoid using the "like" operator with variants of the EMPTY keyword as advised on JSDCLOUD-16343
- is blocked by
-
JSDCLOUD-16343 Quotes removed from EMPTY related words in when using like or = operator in AQL
-
- Closed
-