Set checked state of checkbox based on contains/like

[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

[Alex K.]

Hello,

You can use the following expression:

Code: Select all

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

Thank you.