@Picklist, category parameter. Exact match or not?

I was hoping that someone can vouch whether this is working as designed or not.

My Picklist view is as follows (v is the twistie)

v User One~Headquarter

doc A

doc B

v User One~Headquarter12345

doc C

doc D

My picklist code is as follows

X:=@PickList([Custom]:[Single];“”:“”;“lkAssetPIC”;“Title”;“Select something please:”; 2; @Name([CN]; rl_ExistingPIC +“~”+ rl_ExistingLocation));

Problem is even if I put in “User One” in rl_ExistingPIC and “Headquarter12345” in rl_ExistingLocation the picklist view would show doc A and doc B instead of doc C and doc D

It seemed that the category is compared not as exact match. Is it behaviour normal and what can I do as a workaround ?

Regards

Tinus Riyanto

Subject: @Picklist, category parameter. Exact match or not ?

This is a slight problem in your picklist formula. The closing ‘)’ in @Name is in the wrong place. Only the ‘rl_ExistingPIC’ I’m assuming is the name that should be converted to common format.

Here’s the ammended formula:

X:=@PickList([Custom]:[Single];“”:“”;“lkAssetPIC”;“Title”;“Select something please:”; 2; @Name([CN]; rl_ExistingPIC) +“~”+ rl_ExistingLocation);

See if that works any better for you.

Alex