Differences
This shows you the differences between two versions of the page.
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] rozanna | tutorial:working_with_lists [2020/01/13 08:32] – [Finding records] lou | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Working with lists ====== | + | {{indexmenu_n> |
+ | ====== | ||
- | {{entry> | ||
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: | ||
- | {{ : | + | {{ : |
**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. | ||
+ | |||
===== Finding records ===== | ===== Finding records ===== | ||
Line 91: | Line 96: | ||
- Click on " | - Click on " | ||
- | - Click on "is greater than" in the Comparisons list | + | - Click on " |
- Enter " | - Enter " | ||
- Click the ** Add line** button | - Click the ** Add line** button | ||
- Scroll down the available fields lists then click on " | - Scroll down the available fields lists then click on " | ||
- | - Click on " | + | - Click on " |
- Enter " | - Enter " | ||
- 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 | ||
- | {{ : | + | {{ : |
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]] | + | Thanks for working through the tutorial. We hope you learnt something useful, and now feel confident to start using mSupply! |
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | | | ||
---- struct data ---- | ---- struct data ---- | ||
---- | ---- | ||