Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
admin:the_log [2017/08/08 00:18] – rozanna | admin:the_log [2023/01/24 09:23] – [Custom query] Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{indexmenu_n> | + | {{indexmenu_n> |
- | =====The log ===== | + | ====== 25.19. |
+ | The log contains records of who did what and when in the system. It's a useful place to look to find out what happened to certain records and when certain things were done. Some events (lots!) are always logged by mSupply but some are optional and are chosen in the //Log// tab of the [[preferences: | ||
+ | To view the log, choose //View log...// from the //Special// menu. You will be shown all today' | ||
- | The log contains records of who did what and when in the system. It's a useful place to look to find out what happened to certain records and when certain things were done. To view the log choose //View log// from the //Admin// menu. You will be asked how many days history to view (the default is 7 days) | + | {{ : |
- | It displays a list of significant events, along with the date, the time and the user. Some events are always logged by mSupply but others can be chosen in the [[preferences: | + | The columns contain this information: |
- | + | * **Date: | |
- | {{ :admin:view_log.png?600 |}} | + | * **Time: |
+ | * **User:** the name of the user who did the operation giving rise to the log entry. | ||
+ | * **Type:** the type of log entry. Can be used for filtering or just telling you which part of the system generated | ||
+ | * **Event:** a description of the event that occurred. | ||
+ | * **Source table:** the name of the table that contains the affected record (if there is one). | ||
+ | * **Record ID:** if there was one, the ID of the record in the database that was affected by the event. | ||
+ | * **Extra information: | ||
+ | * **Store name:** the name of the store that the event occurred in. | ||
Buttons in the window: | Buttons in the window: | ||
- | + | * **Export** Export the log to a tab delimited text file. You can then import this into other applications (such as a spreadsheet application) for editing and printing. | |
- | * // OK// - exit the window | + | * **Print** Prints |
- | * // Order by// - sort the log | + | * **Order by** Sort the log by something than the default date/time order. |
- | * // Find// - find particular records in the log. | + | * **Find** Search for particular records in the log. |
- | * //Export// - allows you to export the log for use in another application | + | * **OK** Close the window. |
- | | + | |
<WRAP center round tip 60%> | <WRAP center round tip 60%> | ||
Line 21: | Line 29: | ||
</ | </ | ||
+ | ==== Dates ==== | ||
+ | If you want to see log records that were generated over a different period then manually edit the dates in the **From** and **To** boxes as required or choose one of the many quick-select options in the drop down list to automatically set them (//Today// is selected by default): | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ==== Event types ==== | ||
+ | Additionally, | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | ==== Custom query ==== | ||
- | Period | + | If you are looking |
- | * Appropriate dates may be entered | + | |
- | * Several periods are available from the drop down list (the default entry is **Today**): | + | |
- | {{ : | + | - Set the date / time period |
+ | - Click on **Find** | ||
+ | - Click on the small right arrow to the right of the first field box | ||
+ | - Select the data type that you are looking for. In this case, we are looking for the '' | ||
+ | - Type in the particular event type that we are looking for. In this case, we are looking for the '' | ||
+ | - Click on **Query** | ||
+ | - Once you are happy with the included results, click on **Print** (or **Export** to produce a text file that can be imported to Excel and manipulated) | ||
- | Choose a specific event: | + | {{ :admin:2018-10-03_10_38_15_log_query.png? |
- | * A second drop down list allows a choice to be made from a number of specific events (the default entry is **All**): | + | |
- | {{ : | ||
- | See [[.:tables_fields: | + | \\ |
+ | \\ | ||
+ | | // Previous: | ||
- | // Previous: [[admin: | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||