Page 1 of 1

Set checked state of checkbox based on contains/like

Posted: Tue Feb 13, 2018 3:51 pm
by rickz
I have a table component with a field set as checkbox and want to set the checked state of this checkbox based on an if condition.
If I would have written this in SQL Server I'd do it in this way:

IF ds2.Aardrailsysteem LIKE '%Hoofd aardrail%'
BEGIN
RETURN TRUE
END
ELSE
BEGIN
RETURN FALSE
END

Would it be possible to do it in such a way?
{IIF ds2.Aardrailsysteem LIKE '%Hoofd aardrail%', true, false}

I'm curious how I should handle LIKE or contains for the checkbox in Stimulsoft

Re: Set checked state of checkbox based on contains/like

Posted: Wed Feb 14, 2018 9:15 am
by Alex K.
Hello,

You can use the following expression:

Code: Select all

{IIF(Categories.CategoryName.Contains("Prod"), true, false)}
Thank you.