On most programs that add or edit records in a table, the first window display is a list of records. Here is the main list for the Customer master in Accounts Receivable:
There are four parts to the list window:
- Start Prompt (top)
- List display (middle)
- Buttons and Status Bar (bottom)
Page 1 — list window
Page 2 — start prompt
Page 3 — list display
Page 4 — mouse and keyboard
Page 5 — buttons and status bar
Next — Start Prompt >
The count reserved word is used in to print a count of fields. The count can be filtered by conditions and the values of other fields. There are two forms for the count reserved word.
Page 1 — count
Page 2 — end count
Page 3 — count as column
Next – End Count >
In the Finding Stuff series, there are a number of ways to find and filter data: wildcard, zoom, find, select and Quiz Select.
This article is on ZOOM.
Zoom is a filter on a Telios list. The filter is set from the column value of the highlighted column. Clear?
Okay, here is an example. We go into the Customer Master in Telios:
The status bar displays ZOOM if the list supports zoom.
There are lots of ways to find data: wildcard, zoom, find, select, popups, quiz select…
Here we start with the simple: the wildcard.
Normally, when we want to look up something, we just type in the name, or the first part of the name. In the Vendor master program, we’re looking for a vendor called Warehouse Club, Inc.
This series on finding stuff has wildcard, zoom, find, select and Quiz select.
So what’s more basic that Find itself?
This function is standard on virtually every Telios list. Okay, probably not on all the popups, but just about everywhere else.
So, how does it work? We look at the main Sales Order list for an example:
For the sake of documentation, the Find options are located on the context menu (right-click or press M, or CTRL + SHIFT + F10). On most of these menus they are buried in the “Other” category – primarily because CTRL-F and CTRL-G are pretty much the standard for the find and find next functions.
The Edit window is used to add, change and delete individual records. In most cases the Edit window is associated with a List window.
The Edit window may have line items and sub-sections like the Inventory Master Edit window:
Or, it can simply have fields from the corresponding table:
In both cases, the button at the lower right hand corner will return to the main List window.
Page 1 — edit window
Page 2 — the buttons
Page 3 — find field
Page 4 — field TAG
Page 5 — the edit field
Next – The Buttons >
The Combo Window combines a list of records with edit fields all in one window.
The most basic type is where the records are managed in a single list:
SQL returns every field on every row selected on a query. You often don’t want every field to print on every row. So… we have this reserved word.
Where count and summarize keep track of unique values, repeat deals entirely with consecutive values. If the values of the records are like this:
A B B C B A A C C B B A — the printing would be like this:
A B C B A C B A
There are two forms.
- norepeat — skips print of duplicate value
- repeat on — accepts modifiers. Whenever the target field or any one of the modifiers change, the field prints.
Page 1 — repeat
Page 2 — norepeat
Page 3 — repeat on
Page 4 — repeat on page
Next – norepeat >
summarize is used in two ways:
- For numeric fields, summarize will calculate a running total of the field. The on arguments then determine when the accumulated value prints. When the field prints, the running total is reset to zero.
Where break will print totals under an existing column, summarize prints its values in a separate column.
- For date and text fields, summarize acts as a filter rather than an accumulator. The on arguments determine when the date or text field prints.
All summarize statements require at least one following ‘on’ reserved word.
Page 1 — summarize
Page 2 — summarize syntax
Page 3 — numeric summarize
Page 4 — date summarize
Page 5 — expression summarize
Page 6 — text summarize
Next – summarize syntax >
A mask is a literal value (enclosed in quotation marks or dictionary words) that is used to format field values. Captions are a special form of a mask.
Page 1 — mask
Page 2 — the asterisk
Page 3 — numeric masks
Page 4 — decimal masks
Page 5 — date mask
Next – the asterisk >