Hi! I'm trying to do a simple set expression to select the value '* Akut 2 4 tim' from the field 'Priokod', but I'm not getting any results, whereas the value '* 01v' returns a correct value. Any ideas what could be wrong here?
Working correctly: {$<Priokod={'* 01v'}>} [Median timmar rem-svar])
Not working: {$<Priokod={'* Akut 2 inom 4 tim'}>} [Median timmar rem-svar])
If you want to query a sub-string you should use double-quotes, like:
{$<Priokod={"* Akut 2 inom 4 tim"}>}
Further make sure that your string-query is equally to the field-values - maybe the origin field has double spaces or any not visible chars like tabs, line-breaks or similar ones or is in any other way different.
Another point - if it's nearly the complete expression (the ending bracket speaks against it) - it would mean that's an implicit only() aggregation and here it returns NULL if there isn't an unique value else several ones available.
