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 [2017/05/22 04:08] – [Finding records] rozannatutorial: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 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 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