Property search syntax

Important:

• When you search, you must type the entire value.
• Exact searches are case sensitive; lower and upper case letters affect the results. Contains searches are not case sensitive.

Property Values

• Search across properties for matching values by typing the value following \\.

  \\Firstname  Returns results that exactly match the word Firstname.
  -or-
  \\"Firstname Lastname"  Returns results that match the phrase Firstname Lastname

Properties

• If you know that your model has a defined property for Material and that some materials are plastic, type one of the following:

  \\Material\=:PLASTIC  Returns exact results where the value for the property Material exactly matches PLASTIC.

  \\Material:plastic  Returns results where the value for the property Material contains any form of plastic. For example, PLASTIC or black plastic.

  

Wildcard Searches

• Use ? as a single character wildcard search. Use * as a multiple character wildcard search.

  \\ho?e  Returns results for any matching property value, such as hose or hole.
  \\hos*  Returns results for any matching property value.
  \\material:plas*  Returns results for matching entries in the material field.
  \\material:plast*c  Returns results for matching entries in the material field.

Date and Range Searches

• If your dates are formatted as yyyy-MM-dd or yyyy-MM-dd HH:mm:ss (hyphens may also be formatted as forward slashes, e.g. yyyy/MM/dd), they will be recognized as dates and you can conduct date range searches. Other date formats will be treated as text strings that you will have to specifically search for.

  \\[2018-01-01 TO 2019-01-01]  Returns results with a date that falls within or on one of those dates.
  \\last_saved: “2019-01-01 23:59:59”  Returns results with the given date and time in the Last Saved field.

• Values that appear to be integer or decimal numbers will allow range searches.

  \\width: [7.1 TO 7.9]  Returns results in the field width with a matching value (inclusive).

Special Characters and Conditional Operators

• Parentheses, AND, OR, plus, minus, and colon may all be used to clarify your search.

  \\Material:(+Composite -Paper)  Returns results that have Composite for the material, which does not also have the material Paper.
  \\Material:Metal AND (created_by:Ann OR created_by:Jane)  Returns exact results with metal as the material that was also created by Ann or Jane.

• Searching for two terms without otherwise specifying will treat the search as though it had an OR between them.

  \\Material:metal Material:plastic  Returns results that have a material that is either metal or plastic.

• When a property or a value contains a space, such as Document Number or black plastic, use the following operators:
  • For properties, escape the space with a backslash.
    \\Document\ Number\=:126
  • For values, use backslashes or double quotation marks.
    \\Material\=:Black\ plastic
\\Material\=:”Black plastic”