Open topic with navigation
Use the Datasheet Results Filter dialog to select a subset of the records returned through Form Results, Custom Elements, or Page Results for a Datasheet Element. The Datasheet Results Filter dialog is not available for Custom Query results - filter results for custom queries within the SQL query.
After defining a Form Result, Custom Element, or Page Result view for a Datasheet Element, click the Element tool icon and then click the Filter icon to open this dialog. You can also display this dialog by clicking the edit icon within the Datasheet Views dialog.
If the Datasheet has more than one view, first pick the view you want to filter from the dropdown.
When first opened for a Form Result or Custom Element view, the Datasheet Results Filter dialog displays as shown below.
Select Subset of records to turn on filtering and expand the dialog. You can turn filtering off by selecting All records. Note that if you turn off filtering, CommonSpot does not save filter statements or settings. If you turn filtering back on, you will have to recreate statements or settings.
Check this option to use QBE criteria to filter information returned in a Datasheet. For more information, see Query-by-example Element.
Add filter statements by selecting a field, a comparison operator, and entering a comparison value. Optionally refine statements by adding logical AND or OR statements:
See Search Tips in the Contributor's Reference for more detail.
In many cases, another dialog box appears. For example:
See Feed Index Filter Properties for details on completing this dialog.
This checkbox option displays from the Datasheet Results filter only and defaults to disabled. Use this option to optionally enable temporary results filtering for anonymous or authenticated end users. Choosing this option displays an Edit Filter button above the Datasheet view, with a dropdown if more than one view is defined, as shown below. The current default filtering results display.
Saving a filter stores it in session space - it is not persistently updated- and displays a Restore Filter button for optionally clearing the session filter and re-displaying default filter results.
This option is available as of release 9.0 and does not affect Datasheets created before that release.
You can download PDF versions of the Content Contributor's, Administrator's, and Elements Reference documents from the support section of paperthin.com (requires login).
Sites upgrading from versions earlier than release 6.0 should review the following (from the support section of paperthin.com - requires login):
For technical support:
Open topic with navigation