Help with CONTAINS in a rule

Rennur

Hi all,

I'd like to check if the plain text choice attribute CONTAINS a word by using the CONTAINS function, but to exclude choices that are two words and include that search word.

Eg,
Plain text attribute with choices (checkbox format) : Salt, Salt and Pepper, Pepper, Spices
Checkbox fields are stored in DB as @Salt@Salt & Pepper@Pepper@Spices.
Code:
If BO.Choices CONTAINS 'Salt' Then do something...
Problem:
When 'Salt' is NOT checked, and if 'Salt & Pepper' is checked, then the rule will execute as true since "Salt & Pepper' included the word 'Salt' .
How I'd like it to work:
I need to check that only choice 'Salt' is checked, all other two word choices that include the word 'Salt' are ignored.
Is there a FUNCTION to do that.

tford

Is it as simple as looking for the & and ignoring if & is checked?

hpl123

Rennur,
I was also going to suggest the same solution/comment Tom pointed out but if that don´t work, I am quite sure you can do something else using the existing Text functions. They are real powerful actually 🙂.

Rennur

Is it as simple as looking for the & and ignoring if & is checked?

Tom,
That would work if the rule specifically states the values to check for. My issue is that I need to use the BO.Attribute in the rule not the specific Attribute values.

e.g:
If BO1.Attrbute CONTAINS BO2.Attribute Then ..... (Unlike BO1, BO2.Attribute is not a checkbox, only on value can be selected. BO1 is the checkbox with muti values)
Problem
If my BO1.Attribute record has only 'Salt & Pepper' checked and the BO2.Attribute is set as 'Salt', the rule will execute since 'Salt' is in 'Salt & Pepper' i.e BO1.Attribute (Salt & Pepper) CONTAINS BO2.Attribute (Salt).

Since BO1.Attribute is a check box, it can have Salt and Salt & Pepper checked at the same time.
The record in the database stores the checked values as Salt@Salt & Pepper, is there a way/function to have the system check that record for only the word 'Salt' as a whole value, ignoring any other values within the record that have 'Salt' as part of the whole checked value.

I am quite sure you can do something else using the existing Text functions.

Henrik,
Can you give me an example if possible?

Cheers

tford

Is this Salt, Salt & Pepper, etc your real situation or are you trying to use this as an example?

I do better knowing the real situation.

tford

I think the problem is that you were using CONTAINS rather than IN.

I've attached a sample BSV which should help.

1- Click "New Checker Values" and create four instances: Salt, Salt & Pepper, Pepper, Spices ... then click "Close"
2- Click "Change login details'
a- Select a value in the "Check this" field
b- Select checkbox value or values in the "Checkers" section
3- Click save

Result:
The value of Check This YN should show whether the value selected in #1 is found in the checked values from #2

Repeat these steps to show various combinations.

BSV:

ACheck.zip

34.26kB