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
Next revisionBoth sides next revision
tutorial:working_with_lists [2016/12/29 07:44] – [Working with lists] katetutorial:working_with_lists [2020/01/13 08:32] – [Finding records] lou
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 (be they items, names, contacts or another list) that matches the criteria you entered.
Line 9: Line 9:
 When these lists are displayed, a series of buttons are present along the top of the window, as shown: When these lists are displayed, a series of buttons are present along the top of the window, as shown:
  
-{{ :tutorial:lists123.png |}}+{{ :tutorial:lists123.jpg |}}
  
 **Customising the columns viewed: **Clicking the **Customise** button in the toolbar will display this window: **Customising the columns viewed: **Clicking the **Customise** button in the toolbar will display this window:
Line 42: Line 42:
 Should you require two (or more) sort parameters, clicking the ** Order by** button shows the ** Order by** window: Should you require two (or more) sort parameters, clicking the ** Order by** button shows the ** Order by** window:
  
-{{ :tutorial:lists-4.gif }}+{{ :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 "stock_on_hand" field results in thiswindow:+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 "flags" and "item name" fields results in this window:
  
-{{ :tutorial:lists-5.gif }}+{{ :tutorial:lists-5.jpeg }}
  
 (You can also drag fields to the right, or click the right-pointing arrow after highlighting the field on the left) (You can also drag fields to the right, or click the right-pointing arrow after highlighting the field on the left)
Line 60: Line 60:
 **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. **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.gif }}+{{ :tutorial:lists-6.jpeg }}
  
 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.
Line 67: Line 67:
  
 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.
 +
 +===== Printing lists =====
 +
 +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.
 +
  
 ===== Finding records ===== ===== Finding records =====
Line 74: Line 79:
 This button shows a simple find window where you can enter the start of the item name or code. This button shows a simple find window where you can enter the start of the item name or code.
  
-{{ :tutorial:item_find1.jpg?500 }}+{{ :tutorial:item_find1.jpeg? |}}
  
 **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 **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
  
-{{ :tutorial:qury_editr1.jpg?600 }}+{{ :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. Within this window there are four areas from which you have to choose or set a value for each line of a query.
Line 91: Line 96:
  
   - Click on "default_pack_size" in the available fields list.   - Click on "default_pack_size" in the available fields list.
-  - Click on "is greater than" in the Comparisons list+  - Click on "is strictly greater than" in the Comparisons list
   - Enter "10" (no quotes) in the value field.   - Enter "10" (no quotes) in the value field.
   - Click the ** Add line** button   - Click the ** Add line** button
   - Scroll down the available fields lists then click on "code" in the available fields list.   - Scroll down the available fields lists then click on "code" in the available fields list.
-  - Click on "is equal to" in the Comparisons list+  - Click on "is" in the Comparisons list
   - Enter "a@" (no quotes) in the value field.   - Enter "a@" (no quotes) in the value field.
   - Click the **Query** button to perform the query.   - Click the **Query** button to perform the query.
Line 101: Line 106:
 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.
Line 113: Line 118:
 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. 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.
  
-// Previous: [[tutorial:full_tutorial|The Tutorial]]     Next: [[items:item_basics|Understanding Items]] //+Thanks for working through the tutorial. We hope you learnt something useful, and now feel confident to start using mSupply! 
 + 
 +\\ 
 +\\ 
 +|  //  Previous:  **[[tutorial:quotes]]** | | Next: **[[tutorial:where_next]]** //  |
 ---- struct data ---- ---- struct data ----
 ---- ----
  
  • Last modified: 2021/07/04 22:51
  • by Dhanya