Hello,
I have an issue with calculating distinct values in a case property. I get the correct output while testing with join(" ", distinct-values("a a b b c c c")) as mentioned in the manual but when I try with the query below, the function is not working properly.
I tried it out with those values and I do see that duplicate value removed. Your screenshot shows the value of all_attendees, which is the input value, but it doesn't show what happens to distinct_attendees - is that also saved to the case? Displayed in a label on the form? I'm wondering if this is a different sort of issue, where all_attendees is inadvertently being referenced instead of the updated value.
I mentioned what is happening with distinct_attendees in the below of image of the previous message. It is working as visible in the form.
I noticed that when we give string value inside " ", the function works well, but if we provide any other case properties such as all_attendees(multichoice value) it can not separate. Should I transform the value to a string value first? What do you thing?