Using AND, OR, and NOT Operators in Search

SOLIDWORKS PDM supports AND, OR, and NOT operators in input search criteria in edit-box type fields on search cards.

You can use these search operators in any search card, Web2 search, the SOLIDWORKS PDM Search tool, and quick search.

Rules:

• Search strings are case-insensitive.
• Operators are case-sensitive and must be capitalized.
• For variables of a numeric or date type, the valid operators are: =, !=, <, <=, >, >=.
• If the search string contains any of the following characters: =, <, >, !, &, |, (, ), {, }, :, ", or \, you must precede the character with an escape symbol. Alternatively, enclose the whole search string in double quotation marks.

  For example, to search for string article:1, enter the input string as article\:1 or "article:1".

• Rules for using escape symbol:

  Search for String with	Input String
  Double quotation marks	String with an escape symbol \. For example, to search for "speaker", enter the string as \"speaker\"
  Double quotation marks that are a part of an explicit search	String with an escape symbol \. For example, to search for 3" pipe, enter the string as "3\" pipe".
  Numeric constant followed by "	String with or without escape symbol. For example, to search for a length value such as 3", enter the search string as 3\" or 3".
  Exclamation mark	String with an escape symbol \. For example, to search for Alert!, enter the string as Alert\!.
  Colon	String with an escape symbol \. For example, to search for 2:1, enter the string as 2\:1.
  Parenthesis	String with an escape symbol \. For example, to search for 9)Articles, enter the string as 9\)Articles.

• In case of multiple operators used in a search, SOLIDWORKS PDM evaluates the search operators in this order: (), NOT, AND, and OR.
• You can use AND, OR, and NOT search operators or their equivalent symbols &, |, ! respectively.
• You can search for text, integer number, float, and date type data.
• You can use the AND and OR operators with or without the :. For example, for AND operator, use AND, AND:, &, or &:.
• The search field supports * and ? as wildcard characters.
• You can use = to search for an exact string. For example, to search for a Tools string, enter the search string as =Tools.
• In case of a string that contains more than one word, you can use "" to search for the string in the same order of words. For example, to search for pipe tools, enter "pipe tools".