Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I am trying to use set analysis in my expression to do something such as a 'like' or a 'substring'.
I have tried many methods but I don't have the result I expect.
The code:
if (getselectedcount(ANNEE)>0 and getselectedcount(MOIS)>0, Count(
{$ < ANNEEEVENEMENT = {$(=getfieldselections(ANNEE, ','))}, MOISEVENEMENT = {$(=getfieldselections(MOIS, ','))}, TYPE_EVENEMENT = {"like '%recours%'"} >}
ID_MESURE), Count(
{$ < TYPE_EVENEMENT = {"like '%recours%'"}, ANNEEEVENEMENT = {$(=year(today()))}, MOISEVENEMENT = {Mar} >}
ID_MESURE))
I think my problem is the {"like '%recours%'"}
I have also tried to create a variable vEvenement = substringcount(TYPE_EVENEMENT, recours) and use the expression ...{$ < vEvenement = {">0"} ...
I have also tried vEvenement = mid (TYPE_EVENEMENT, index(TYPE_EVENEMENT, 'recours'), 7) and use the expression ...{$ <vEvenement = {"recours"} ...
Probably I have mistakes in my expressions but I don't have the right results.
Thanks!
I got the result with something like "field name" = {"*recours*"}. It was a mistake from my part I used the wrong field name.
Thanks