You are viewing limited content. For full access, please sign in.

Question

How do run a case insensitive select query rule?

Laserfiche Cloud Rules

Updated April 27

asked on April 24

Hi everyone,

As the subject asks. I want to check to see if a value exists in a lookup table before executing further activites. Can the select quey be executed as case-insensitive?

0 0

Replies

replied on April 26

>>Can the select quey be executed as case-insensitive

I don't believe so. I usually pass in a lowercase and an uppercase 'where'.

Hopefully my original dataset is standardized upper or lower case (and not camelcase or something else). Just to be sure I will standardize how the the data gets saved to the lookup table e.g. sanitize the column as all caps or all lowercase.

0 0

replied on April 27

Hi Anthony,

It'll work but not as visually nice as just using sentance case because I'm using the data to populate drop-downs. It would be great if there were upper() or lower() functions I could use for comparissons.

1 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked April 24
Updated April 27
164 views