Having a bit of difficulty in JQL. At one stage of one of our queries we want to group by a couple of different properties, which have been found by joining events and people. These are the qualities we are trying to join by.
"user.properties['Landing Page Source']",
The issue is that one of the variables has spaces in the name of it, meaning the dot notation to call that property does not work, however even when using the bracket notation, it just comes back with the second value as null, despite the variable not being null.
i.e. results in the form;
My question is, does the bracket notation work in JQL, and if not, does anyone have any other ideas for how I could call this variable?
Best answer by michael
Bracket notation does work in JQL, and normally your notation as shown would be totally right if it were being used in a selector or a filter.
user.properties['Landing Page Source']
However, even though this property is multiple words with spaces in between, since this criteria is already in quotes as part of a groupBy key, you don't need to use bracket notation.
As such, your groupBy keys would look as follows:
"user.properties.Landing Page Source",
Does that get you the results you need?