Difference between revisions of "About the List View"
From LongJump Support Wiki
imported>Aeric (Created page with "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 mo…") |
imported>Aeric |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
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 | 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 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: | 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: | ||
::[[File:ListView.png]] | ::[[File:ListView.png]] | ||
| Line 8: | Line 8: | ||
# Click the Wrench icon [[File:WrenchIcon.png]] for a list of options you can use for [[Views#Managing Views|Managing the View]]. | # Click the Wrench icon [[File:WrenchIcon.png]] for a list of options you can use for [[Views#Managing Views|Managing the View]]. | ||
#:[[File:WrenchIcon_ViewMenu.png]] | #:[[File:WrenchIcon_ViewMenu.png]] | ||
# Click an entry in the Alphabetic Index to | # Click a column heading to sort the records on that column.<br>(The column icon changes to show that it has been sorted.) | ||
# Click again to reverse the sort. | |||
# Click an entry in the Alphabetic Index to limit the list to values starting with that letter in the most recently selected column. | |||
# Type in a value and click the Magnifier icon [[File: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. | # Type in a value and click the Magnifier icon [[File: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. | ||
# 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]].}} | |||
Latest revision as of 22:59, 8 April 2013
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 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:
- Choose from standard and custom Views to determine which records are selected and which information is displayed.
- Click the Wrench icon
for a list of options you can use for Managing the View.
- Click a column heading to sort the records on that column.
(The column icon changes to show that it has been sorted.) - Click again to reverse the sort.
- Click an entry in the Alphabetic Index to limit the list to values starting with that letter in the most recently selected column.
- Type in a value and click the Magnifier icon
to search for a record with that value. Click the down arrow to get a list of things you've searched on before. - Click the double down arrow icon
to do advanced filtering:
- 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
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.
