Hello all, please, i want to get some cases properties into lookup table but i want to have distinct values of items. how to do it .
it tried the code below but it doesn't work.
join("", distinct-values(instance('casedb')/casedb/case[@case_type = 'beneficiaire'][@status = 'open']/Beneficiaire_Raison_Social))
"Beneficiaire_raison_Social" is the case property i want to fetch into the lookup table, it can be the same for many cases so i want to have distinct value of each.
thanks in advance