tutorial:working_with_lists

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
tutorial:working_with_lists [2017/05/22 04:04] – [Finding records] rozannatutorial:working_with_lists [2021/07/04 22:51] (current) – [Customising] Dhanya
Line 1: Line 1:
-====== Working with lists ======+{{indexmenu_n>110}} 
 +====== 3.11. Working with lists ======
  
-{{entry>3.Tutorial/4.Working with lists|*}} 
  
-Whenever you perform a search in mSupply resulting in more than one item being found, you will be presented with a list of records (be they items, names, contacts or another list) that matches the criteria you entered.+Whenever you perform a search in mSupply resulting in more than one item being found, you will be presented with a list of records (e.g. items, names, contacts or another list) that match the criteria you entered.
  
-mSupply uses two types of list display. Shorter lists, such as those you see when you view an invoiceor view the stock for an item employ a list with a striped background. These lists have resizable and moveable columnsand have an indicator to show the sorted column. Their use is discussed in the next chapter. In this chapter we are concerned with tools for handling lists of names and items and transactions, which run into hundreds of thousands or millions of records.+mSupply uses two types of list display.  
 +  - Shorter lists, such as an invoice or stock lists, are displayed with a striped background. These lists have resizable and moveable columns. They also and have an indicator to show the sorted column. Their use is discussed in the next chapter.  
 +  - Longer lists, such as item and transaction lists, which can have thousands or millions of records.   
 +In this tutorial section, look at the tools for handling of the longer lists.
  
-When these lists are displayed, a series of buttons are present along the top of the window, as shown:+When longer lists are displayed, a series of buttons are available along the top of the window, as shown in the below screenshot (note only a small list is shown for the purposes of the tutorial):
  
-{{ :tutorial:lists123.png |}}+{{ :tutorial:lists123.jpg |}}
  
-**Customising the columns viewed: **Clicking the **Customise** button in the toolbar will display this window: 
  
-{{ :tutorial:item_list_2.png?600 }}+=====General=====
  
-On the right is a list of columns you are currently using.+**Viewing or editing particular record:** To view or edit a record, double-click the row in the list you wish to view. A new window will open showing the details of the record you clicked.
  
-On the left is a list of available columns. To add a column to the view, click on the item in the left-hand list, then click the right--pointing button in between the lists. You can control-click to add multiple columns at the same time.+**Column widths:** The easiest way to change column widths is to drag the dividers (the dividing line) between the columns in the list view. Note that if the total column width is too wide for the window, a horizontal scroll bar is added to the list allowing you to view columns to the right of those displayed.
  
-To remove a column select the column(s) to remove from the right-hand list, and click the left-pointing button to move the columns back to the available list. You can not remove the first column in chosen list, as it is hidden key column to identify each row uniquely.+**Choosing the column order:** To change the sequence of the columns in list, drag a column header to a new location
  
-**Renaming columns:** By clicking twice on a field name in the right hand list you can change the column title. 
  
-**Column widths: **The easiest way to set column widths is to drag the dividers between the columns in the list view..+=====Customising=====
  
-Note that if the total column width is too wide for the window, a horizontal scroll bar is added to the list allowing you to view columns to the right of those displayed.+Clicking the //Customise// button in the toolbar will display this window:
  
-**Choosing the column order**To change the sequence of the columns in a list, drag a column header to a new location. This is done when viewing the // Item list// window, not in the // Customise columns// window.+{{ :tutorial:pasted:20210704-225114.png }}
  
-**Viewing or editing a particular record: **To view or edit a record, double-click the row in the list you wish to viewA new window will open showing the details of the record you clicked.+The list on the left-hand side gives all of the available fields (displayed in columns)The list on the right-hand side is a list of fields (columns) you are currently using.
  
-**Ordering (Sorting) lists: **Ordering a list is the same as sorting itFrequently a column may be ordered by clicking on the column heading. The column will be sorted in ascending order** Ascending** means:+To add field to your view, click on the field in the left-hand list. You can control-click to add multiple columns at the same timeThen click //> >//, the right-pointing button, in-between the lists.
  
 +To remove a field from your view, select the field(s) to remove from the right-hand list,. Then click //< <//, the left-pointing button, to move the fields back to the available list. 
 +
 +You can not remove the first column for any list as it is the key column to identify each row uniquely.
 +
 +**Renaming columns:** By double-clicking on a field name in the right-hand list you can change the column title.
 +
 +
 +=====Ordering=====
 +
 +Ordering a list is the same as sorting it. Frequently a column may be ordered by clicking on the column heading. The column will be sorted in ascending order. **Ascending** means:
   * A > Z (upper and lowercase are not considered different)   * A > Z (upper and lowercase are not considered different)
   * 1 > 2 > 3 for numbers   * 1 > 2 > 3 for numbers
   * earlier dates to later dates   * earlier dates to later dates
 +** Descending** means the opposite of **Ascending**.
  
-** Descending** means the opposite of ** Ascending** .+<WRAP center round tip 550px>Note that ordering a list does not add or remove any records from the listIt simply changes the order in which the records are displayed.</WRAP>
  
-Note that ordering a list does not add or remove any records from the list. It simply changes the order in which the records are displayed. +Should you require two (or more) sort parameters, clicking the //Order by// button opens the following window:
-Should you require two (or more) sort parameters, clicking the ** Order by** button shows the ** Order by** window:+
  
 {{ :tutorial:lists-4.jpeg }} {{ :tutorial:lists-4.jpeg }}
  
-The ** Available Fields** list will reflect the type of records you are viewing. The list shown is for ** Items** . To order by a particular field, double-click it in the left-hand list; double-clicking on the "flagsand "item namefields results in this window:+The //Available Fields// list will reflect the type of records you are viewing. In our example, the list shown is for **Items**.  
 + 
 +To order by a particular field, double-click it in the left-hand list.  You can also drag fields to the right-hand list, or highlight the field in the left-hand list and click the right-pointing arrow. You can order by multiple fields by adding further fields to the right-hand list. Double-clicking on the //flags// and //item name// fields in our example results in this window:
  
 {{ :tutorial:lists-5.jpeg }} {{ :tutorial:lists-5.jpeg }}
  
-(You can also drag fields to the rightor click the right-pointing arrow after highlighting the field on the left)+**To remove a field:** Highlight the field in the **Ordered by Fields** listthen click the single left-pointing arrow between the two lists. The double left-pointing arrow will clear all fields from the **Ordered by Fields** list 
  
-You can order by multiple fields by adding further fields to the right-hand list.+**To change field ordering:** Each item in the **Ordered by Fields** list has a small triangle to the right. If pointing up, the ordering will be ascending. If pointing down, descending. To change the direction, click on the //triangle// for each field.
  
-**To change to ascending/descending ordering: **Each item in the "Ordered by Fields" list has a small triangle to the right. If pointing up, the ordering will be ascending. If pointing down, descending. +**Using formulae:** If you want to order by a formula, click the //Add Formula// button. Here the formula window is shown, and the formula //Length([items]code)// has been entered.
- +
-To change the direction, click on the triangle. +
- +
-**To remove a field: **Highlight the field in the right-hand column, then click the red single left-pointing arrow between the two lists. The double left-pointing arrow will clear the "Ordered by Fields" list +
- +
-**Using formulae: **If you want to order by a formula, click the ** Add formula** button. Here the formula window is shown, and the formula "Length([items]code)has been entered.+
  
 {{ :tutorial:lists-6.jpeg }} {{ :tutorial:lists-6.jpeg }}
Line 64: Line 71:
 Using this formula would allow you to identify items whose item code is shorter/longer than your organisation's specifications. Using this formula would allow you to identify items whose item code is shorter/longer than your organisation's specifications.
  
-Click the OK button to close the window.+Click the //OK// button to close the window.
  
-Once the details are entered, click the ** Order by** button to order the list.+Once the details are entered, click the //Order by// button to order the list.
  
-===== Finding records ===== 
  
-In the item list shown above there is a // Find// button.+===== Printing lists =====
  
-This button shows a simple find window where you can enter the start of the item name or code.+You can press the print icon to send the list to Excel. The list will display in Excel with the column headings you have selected.
  
-{{ :tutorial:item_find1.jpg?500 }} 
  
-**Complex finds: **The window shown above has a // Complex find// button. This allows you to perform a search using multiple criteria. Clicking this button shows the query editor+=====Find=====
  
-{{ :tutorial:qury_editr1.jpeg?600 }}+This button opens a simple find window where you can enter the start of the item name or code.
  
-Within this window there are four areas from which you have to choose or set a value for each line of a query.+{{ :tutorial:item_find1.jpeg? |}}
  
-  - Available fields,from where you make your selection +**Complex finds:** The window shown above has a //Complex Find// buttonThis allows you to perform a search using multiple criteriaClicking this button shows the query editor
-  - Operands, from where you select the one appropriate +
-  - Value, where you enter your specific criterion +
-  - For queries with more than one criterion, click ** Add line** .then .... +
-  - Click the appropriate conjunction.+
  
-For example, if you want to find all items whose default pack size is greater than ten and whose code starts with "A" these are the required steps:+{{ :tutorial:qury_editr1.jpeg? |}} 
 + 
 +Within this window there are four areas from which you have to choose or set a value for each line of a query. 
 +  - Available fields, select the field that you are looking for 
 +  - Operands, select the operand that is appropriate for your search 
 +  - Value, enter your specific criterion 
 +  - For queries with more than one criterion, click //Add line//, then complete as above but also with the appropriate conjunction
  
-  - Click on "default_pack_sizein the available fields list. +For example, if you want to find all items whose default pack size is greater than ten and whose code starts with **A** these are the required steps: 
-  - Click on "is greater thanin the Comparisons list +  - Click on //default_pack_size// in the available fields list 
-  - Enter "10" (no quotes) in the value field. +  - Click on //is strictly greater than// in the Comparisons list 
-  - Click the ** Add line** button +  - Enter ''10'' in the value field 
-  - Scroll down the available fields lists then click on "codein the available fields list. +  - Click the //Add line// button 
-  - Click on "is equal to" in the Comparisons list +  - Scroll down the available fields lists then click on //code// in the available fields list. 
-  - Enter "a@" (no quotes) in the value field. +  - Click on //is// in the Comparisons list 
-  - Click the **Query** button to perform the query.+  - Enter ''a@'' in the value field (note the wildcard character @ has been used to find all items whose code has **a** as the first character) 
 +  - Click the //Query// button to perform the query
  
-Before step 8, the window would look like this+Before step 8, the window would look like this:
  
-{{ :tutorial:lists-10.gif }}+{{ :tutorial:lists-10.jpeg |}}
  
 The upper area of the query editor shows a summary of the query that is about to be performed. The upper area of the query editor shows a summary of the query that is about to be performed.
  
-Note that the wildcard character "@" has been used following "a" to find all items whose code has "a" as the first character+This example will return a list of items where both the search criteria are met because the conjunction //And// was used. If you wanted to find items that matched only one of the criteria entered, you would click on the second line in the large upper panel to select it, and then click on the //Or// button where the conjunctions are displayed.
  
-This example will return a list of items where both the search criteria are met, because the conjunction ** And** was used. If you wanted to find items that matched only one of the criteria entered, you would click on the second line in the large upper panel to select itand then click on the // Or// button where the conjunctions are displayed.+**Saving and Using saved queries:** If you have spent time on developing a particular queryand you are likely to use the same query in the future, click the //Save...// button. You will be asked to choose a name and location to save the query. The saved file is very small.
  
-**Saving and Using saved queries: **If you have spent time on developing particular query , and you are likely to use the same query in the future, click the ** Save ** button. You will be asked to choose a name and location to save the query. The saved file is very small.+Then when blank query window is first shown, you can click the //Load...// button and locating the saved query.
  
-When a blank query window is first shown, you can re-use a previously saved query by clicking the ** Load...** button and locating the query file.+Thanks for working through the tutorialWe hope you learnt something useful, and now feel confident to start using mSupply!
  
-// Previous: [[tutorial:full_tutorial|The Tutorial]]     Next: [[items:item_basics|Understanding Items]] //+\\ 
 +\\ 
 +|  //  Previous:  **[[tutorial:quotes]]** | | Next: **[[tutorial:where_next]]** //  |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2017/05/22 04:04
  • by rozanna