You are here: Elements Reference > Form & Datasheet Elements > Datasheet Element > Datasheet Results Filter

 

Datasheet Results Filter

The Datasheet Results Filter dialog allows you to control the data rows that appear in a Form Result, Custom Element, or Page Result view of a Datasheet Element. For a Custom Query Result view, you must incorporate filtering within the SQL query; the Datasheet Results Filter dialog is not available.

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 the Datasheet Results Filter dialog.

If the datasheet has more than one view, first select the view that you want to filter from the drop-down list.

You can also display this dialog by clicking on the pencil icon within the Datasheet Views dialog.

When first opened for a Form Result or Custom Element view, the Datasheet Results Filter dialog will appear as shown.

Select Subset of records to turn on filtering and expand the dialog. You can turn filtering off by checking “All records”. Note that if you turn off filtering, CommonSpot does not save filter statements. If you turn filtering back on, you will have to recreate the statements.

Check the User Query-by-Example Fields option if a person is able to specify criteria that CommonSpot will use when it filters returned information. For more information, see Query-by-example Element.

Add filter statements by selecting a Field and Operator, and entering a Value. Add additional statements by selecting “AND” or “OR” from the drop-down list.

In many cases, another dialog box appears. For example:

For information on this dialog box, see Feed Index Filter Properties.

 

Related Links


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).


For technical support:

http://www.paperthin.com/support/