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

Question

Question

Field Search "OR" Operator

asked on October 31, 2016 Show version history

To Distinguish Last Name Fields on a Template I have the following Fields.

Last Name

Spouse Last Name

Birth Date

Spouse Birth Date

Is their an easy way to search both fields given the last name matched "Last Name" or "Spouse Last Name" similar to the Text Search which has operators available.

I realize I could use a multi-value field but their is no true way to distinguish or explicitly define which is the "Last Name" vs the "Spouse Last Name" other than the order perhaps the first value being "Last Name" and the second "Spouse Last Name". In fact this will apply to many fields on the Template like Birth Date etc.. so we have to assume and rely that all the 1st values are for one person and all the second values are for the second person which could easily be mistakenly interchanged.

I can write an Advanced Syntax to work and distribute via Attributes but not so user friendly for the end user.

In fact I may need to search something like the following:

If any of the Last Name Values Match and If any of the Birth Date Values Match and If any of the Driver License Numbers Match.

0 0

Replies

replied on November 1, 2016

You will need to use the advanced syntax for this. A custom quick search would make it easier for your users, something like  {[TemplateName]:[Last Name]="%(SearchTerm)"} | {[TemplateName]:[Spouse Last Name]="%(SearchTerm)"} where TemplateName is the name of the template.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.