Database specific search options

In this document the database specific search options are summarized and their usage is shown in different search interfaces.

Result table

SQL SELECT statement for pre-filtering

#### Result table Sets the result table that will contain the cd_id of hits. In case of searching similar structures, the similarity value is also stored in column similarity.
MolSearch APINot applicable.JChemSearch API JChemSearch searcher = new JChemSearch(); searcher.setResultTable (tableName);JChem Oracle CartridgeNot applicable. jcsearch command line toolNot applicable.
See the availability of the option in further ChemAxon products: InstantJChem JChem for Excel * Plexus Suite Home

#### SQL SELECT statement for pre-filtering

#### SQL SELECT statement for pre-filtering
MolSearch APINot applicable. JChemSearch API JChemSearchOptions searchOptions = new JChemSearchOptions(SearchConstants.SUBSTRUCTURE); searchOptions.setFilterQuery(filterQueryString); // ... JChemSearch searcher = new JChemSearch(); searcher.setSearchOptions(searchOptions);Sets the SQL query for filtering. The result should contain cd_id values of the desired records of the structure table. JChem Oracle CartridgeUse the jc_compare operator with filterQuery:select-statementExample: The following SQL statement performs a search on a subset of the structures stored in the JChem-generated table jc_nci_10m and returns the number of structures in the subset which contain aromatic ring. The subset considered for the search is specified to belong to project #502:`SELECT count(*) FROM jc_nci_10m WHERE jc_compare(structure, 'c1ccccc1', 'sep=! t:s!filterQuery:select cd_id from jc_nci_10m where projid = 502') = 1`The query in `select-statement` will be first executed, then the search will be performed only on the rows returned by the `select-statement`. `select-statement` must return a single column containing the identifier of the rows to be included in the search. The row identifier is `cd_id` in case of JChem tables and `rowid` in case of plain Oracle tables.jcsearch command line toolNot applicable.
See the availability of the option in further ChemAxon products: InstantJChem JChem for Excel * Plexus Suite Home

MolSearch APINot applicable. JChemSearch API JChemSearchOptions searchOptions = new JChemSearchOptions(SearchConstants.SUBSTRUCTURE); searchOptions.setFilterQuery(filterQueryString); // ... JChemSearch searcher = new JChemSearch(); searcher.setSearchOptions(searchOptions);Sets the SQL query for filtering. The result should contain cd_id values of the desired records of the structure table. JChem Oracle CartridgeUse the jc_compare operator with filterQuery:select-statementExample: The following SQL statement performs a search on a subset of the structures stored in the JChem-generated table jc_nci_10m and returns the number of structures in the subset which contain aromatic ring. The subset considered for the search is specified to belong to project #502:

SELECT count(*) FROM jc_nci_10m WHERE jc_compare(structure, 'c1ccccc1', 'sep=! t:s!filterQuery:select cd_id from jc_nci_10m where projid = 502') = 1

The query in select-statement will be first executed, then the search will be performed only on the rows returned by the select-statement. select-statement must return a single column containing the identifier of the rows to be included in the search. The row identifier is cd_id in case of JChem tables and rowid in case of plain Oracle tables.jcsearch command line toolNot applicable.

See the availability of the option in further ChemAxon products: InstantJChem JChem for Excel * Plexus Suite Home