topic Re: Problem simple set expression in App Development

Problem simple set expression

oscarjakobsen — Thu, 02 Jan 2025 15:37:15 GMT

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])

Re: Problem simple set expression

Daniel_Pilla — Thu, 02 Jan 2025 16:23:30 GMT

Could you provide some sample values?

Re: Problem simple set expression

marcus_sommer — Thu, 02 Jan 2025 16:56:49 GMT

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.

Re: Problem simple set expression

eddyvargas — Thu, 02 Jan 2025 19:46:26 GMT

try "*Akut*2*4*tim*"