Difference between revisions of "About the List View"

From LongJump Support Wiki
imported>Aeric
imported>Aeric
Line 12: Line 12:
# Click the double down arrow icon [[File:DoubleDownIcon.png]] to do advanced filtering:
# Click the double down arrow icon [[File:DoubleDownIcon.png]] to do advanced filtering:
#:[[File:ListViewFilter.png]]
#:[[File:ListViewFilter.png]]
::;Things to know about filtering:
::* To apply a filter to a checkbox, use "<tt>1</tt>" for Yes/True and "<tt>0</tt>" for No/False values.
::* Specify multiple values using the pipe "<tt><nowiki>|</nowiki></tt>" character. For example: <tt><nowiki>"State equals CA|NY|MN"</nowiki> </tt>
::* Specify an empty numeric field using <tt>BLANK</tt>. For example: <tt>"Phone equals BLANK"</tt>
::* Specify an empty string field using two single-quotes with nothing between them: (<tt><nowiki>''</nowiki></tt>)
:::''Learn more:''[[Complex Expressions]]
{{Note|The filter is not saved with the view. For details on how to include a filter in a View and save it for future use, see [[Filters]].}}

Revision as of 00:36, 30 August 2011

The List or grid is the most common kind of multiple-record view, but there are other kinds of views as well. For example: Tree, Thumbnail, and Calendar displays. (Learn more: Views.)

In a List View, records are displayed in a grid, like a spreadsheet. At the top of the view, under the action buttons, a view control bar gives you many ways to control your view of the data:

ListView.png
  1. Choose from standard and custom Views to determine which records are selected and which information is displayed.
  2. Click the Wrench icon WrenchIcon.png for a list of options you can use for Managing the View.
    WrenchIcon ViewMenu.png
  3. Click an entry in the Alphabetic Index to display only records that start with that letter. (The View must currently be sorted on a text field.)
  4. Type in a value and click the Magnifier icon MagnifierIcon.png to search for a record with that value. Click the down arrow to get a list of things you've searched on before.
  5. Click the double down arrow icon DoubleDownIcon.png to do advanced filtering:
    ListViewFilter.png
Things to know about filtering
  • To apply a filter to a checkbox, use "1" for Yes/True and "0" for No/False values.
  • Specify multiple values using the pipe "|" character. For example: "State equals CA|NY|MN"
  • Specify an empty numeric field using BLANK. For example: "Phone equals BLANK"
  • Specify an empty string field using two single-quotes with nothing between them: ('')
Learn more:Complex Expressions

Notepad.png

Note: The filter is not saved with the view. For details on how to include a filter in a View and save it for future use, see Filters.