Report:MMS/Search Syntax/Allowed Operators
From Intellogist
| Report | Patent Coverage Map | Ratings | Comments |
| This search system report was created by the Intellogist Team and is available for viewing only. If you'd like to share your knowledge on Intellogist, please visit the Best Practices, Glossary, or Community Reports pages. Registered users may be notified of any substantial changes to this report by placing a "watch" on the Revisions page, which is the last page listed in the table of contents. To learn more about using the Intellogist "watchlist," see the Watchlist Help page. | |
  |
|
Allowed Operators
A Boolean logic search can be conducted in MMS only when combining two MMS results sets together. MMS records in Imagination and STN contain no patent data, text, dates, or other common limiters, so these types of limiters can't be used to limit a structure search in MMS. Any operation of this kind must be performed after switching the MMS results (which contain only CN numbers) to the DWPI or Pharm bibliographic files, and adding the limiting term there (e.g. search set 1 AND PY>=1999).
MMS supports AND, OR, and NOT Boolean logic, but can only support two search terms combined with Boolean logic, such as 1 OR 2. Adding a third term (1 OR 2 OR 3) will cause the search to fail.[1]
In ChemAxon's JChem, more flexibility is allowed with the use of Boolean operators. Users can combine query terms using AND/OR, and AND/OR can even be used within a query term to create a composite query term containing multiple terms linked by Boolean operators.[2]
Numeric operators are also available in JChem for some fields, and a drop-down menu beside the field name contains the possible available operators (=, <, <=, Between, etc.).[2] Another available operator for some fields is the IN LIST/NOT IN LIST operator where the user enters a list of values separated by commas.[2]
According to the ChemAxon query builder guide:[2]
Widlcard searches are possible for text fields using the 'like' operator. Use the appropriate wildcard character for the type of database (usually % for zero or more characters and _ for a single character). For instance 'like amimo%' will find all values starting with the term 'amino'. Shortcut operators are provided for some commonly used wildcard searches:Finally, users can search for missing or present values using Is Null/Is Not Null operators.[2]
- 'starts with amino' (equivalent to 'like amino%')
- 'ends with amino' (equivalent to 'like %amino')
- 'contains amino' (equivalent to 'like %amino%')
Sources
- ↑ Berks, Andrew H. “Current state of the art of Markush topological search systems.” World Patent Information, vol. 23, p5-13. 2001.
- ↑ 2.0 2.1 2.2 2.3 2.4 "Query Builder." ChemAxon website, http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/managing_data/queries/query_builder.html. Accessed June 28, 2011.
