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 [2018/10/03 01:44] – [Custom query] mark | 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: | 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: | ||
Line 6: | Line 6: | ||
{{ : | {{ : | ||
+ | |||
+ | The columns contain this information: | ||
+ | * **Date:** the date when the log entry was made. | ||
+ | * **Time:** the time the log entry was made. | ||
+ | * **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 the log entry. | ||
+ | * **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: | ||
Line 28: | Line 39: | ||
{{ : | {{ : | ||
- | See [[.: | ||
==== Custom query ==== | ==== Custom query ==== | ||
- | If you are looking for log records that are not in the list of common event types described above, you will need to create a custom query. | + | If you are looking for log records that are not in the list of common event types described above, you will need to create a custom query. |
- Set the date / time period | - Set the date / time period | ||
Line 42: | Line 52: | ||
- 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) | - 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) | ||
- | {{ : | + | {{ : |
+ | \\ | ||
+ | \\ | ||
+ | | // Previous: | ||
- | // Previous: [[admin: | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||