Trying to Bulk Edit objects from the UI when Advanced AQL filter contains like EMPTY results in "An unknown error occurred"

XMLWordPrintable

    • 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 

            Assignee:
            Bhavya Pathipati
            Reporter:
            Daniel Ocando Espinoza (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: