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

Question

Question

Search Syntax Problem. I added the Pipe character for OR while searching a list field and it says invalid character

asked on September 21, 2015

Here is my syntax. I was either looking to use an OR or Does not Equal option for a list field. I couldn't find an option for Does not Equal so I went with the OR syntax. It just says invalid character.

 

{[Order Document]:[Order Status]="In Purchasing" | [Order Document]:[Order Status]="In Warehouse" | [Order Document]:[Order Status]="Equipment Allocated", [SFDC #]="12345"}

0 0

Replies

replied on October 8, 2015

In addition, with Laserfiche search, using "<>" corresponds to "not equal to".

4 0
replied on September 21, 2015 Show version history

I think '|' is something you can only use between clauses.  You probably want to try:

{[Order Document]:[Order Status]="In Purchasing"} | 
  {[Order Document]:[Order Status]="In Warehouse"} |
  {[Order Document]:[Order Status]="Equipment Allocated", [SFDC #]="12345"}

(but if you want the "SFDC #" part to apply to all three clauses, you'll need to either apply it manually to all three or separate it out into its own clause and join it with '&').

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

Sign in to reply to this post.