Examples of queries for query folders
You can construct queries for query folders that you create. When executed, the queries retrieve objects stored in the repository based on the criteria you specify. You can specify criteria for full text searching which includes the data and metadata of the objects in the repository.
Objects created after a specified date
The following query retrieves all document components that were created after 1 January 2004:
<ishfolderquery>
<!--Metadata Query -->
<ishfields>
<ishfield name="CREATED-ON" level="logical" ishoperator="greaterthan">01/01/2004</ishfield>
</ishfields>
</ishfolderquery>
Maps handled by a specific user
The following query retrieves all Maps for which the user frankc is the coordinator.
<ishfolderquery>
<!--Object type filter -->
<ishobjecttypes>
<ishobjecttype ishtype="ISHMasterDoc"/>
</ishobjecttypes>
<!--Metadata Query -->
<ishfields>
<ishfield name="FCOORDINATOR" level="logical" ishoperator="equal">frankc</ishfield>
</ishfields>
</ishfolderquery>
Topics with a specific content in the identifier
The following query retrieves all topics for which the identifier starts with DN and for which frankc is administrator.
<ishfolderquery>
<ishobjecttypes>
<ishobjecttype ishtype="ISHModule"/>
</ishobjecttypes>
<!--Metadata Query -->
<ishfields>
<ishfield name="CARDELEMENT" level="logical" ishoperator="like">DN%</ishfield>
<ishfield name="FCOORDINATOR" level="logical">frankc</ishfield>
</ishfields>
</ishfolderquery>
Objects with the word install in the title
The following query retrieves all maps and topics that meet the following criteria:
- A title that contains the word install
- Coordinator defined as either John Doe or Albert Einstein
<ishfolderquery>
<!--Object type filter -->
<ishobjecttypes>
<ishobjecttype ishtype="ISHMasterDoc"/>
<ishobjecttype ishtype="ISHModule"/>
</ishobjecttypes>
<!--Metadata Query -->
<ishfields>
<ishfield name="FTITLE" level="logical" ishoperator="like">%install%</ishfield>
<ishfield name="FCOORDINATOR" level="logical" ishoperator="in">John Doe, Albert Einstein</ishfield>
</ishfields>
</ishfolderquery>