18.12.2024
08:56
Hi Guys,
i am a little confused why this easy logic does not work.
I have a single value field which contains an SAP-No. I'd like to know if this No. "is in" a Dictionary (collection by "Return all rows" of Data Source Values).
Always returns the "then" Value of my If-Clause...Think its really an easy mistake i make, but i cant see it :-(
18.12.2024
21:30
Hi Gerd,
I’m not sure whether the IS IN function works and I currently can’t test it myself.
An alternative would be to use the count function. Your data source would be passed as a parameter for the function and you could define the filter for the SAP number in the data source. If the count is > 0 then the number does exist.
I just this for another case this morning, so I’m sure the alternative .
Best regards,
Daniel
19.12.2024
07:52
Hi Gerd,
I’m not sure whether the IS IN function works and I currently can’t test it myself.
An alternative would be to use the count function. Your data source would be passed as a parameter for the function and you could define the filter for the SAP number in the data source. If the count is > 0 then the number does exist.
I just this for another case this morning, so I’m sure the alternative .
Best regards,
Daniel
Hi Daniel,
well your reply gave the right trigger to me. I tried the count function and got an type convertion error there. This switches on the light in my head ;-)
I converted the SAP-Number (which is a text field) into an decimal and the IS IN function works.
So thanks for your assistance!!
Have a great christmas and a good start in 2025
Regards
Gerd
