The log dashboard enables you to understand all the activities in the system.

Field name

Type

Definition

Main relationships with other tables

id

text

Primary key for the table log_all

client_id

text

This field is not maintained anymore

client_name

text

This field is not maintained anymore

timestamp

timestamp

Server time (time when the action is registered in the log at the time of the server)

bi_timestamp

timestamp

Local time (time when the action is made at the local time)

last_synchro

timestamp

Last time the mobile user synchronised before doing the action

system_action

boolean

True= The action has been automatically triggered by the system
False=The action has been manually triggered by the user

user_id

text

User id

= mobile_users.id
=teams_mobile_users.user_id

user_type

text

MOBILE = the action has been made on the mobile
WEB = the action has been made on the webapp

user_name

text

Name of the user as registered at the time of the action

user_phone

text

Phone of the user as registered at the time of the action

=mobile_users.phone (except if the phone number has changed)

user_email

text

Email of the user as registered at the time of the action

action_code

text

The main options are:
- ARCHIVE_DASHBOARDS: archive multiple dashboards (by selecting a group of items and doing an edit action)
ARCHIVE_ITEM: archive a single item
ARCHIVE_ITEMS: archive multiple items (by selecting a group of items and doing an archive action)
ARCHIVE_LIST: archive a single list
ARCHIVE_TEAM: archive a single team
ARCHIVE_TEAMS:archive multiple items (by selecting a group of items and doing an archive action)
ARCHIVE_WORKFLOW: archive a single item
ASSIGN_ITEM: assign a single item
ASSIGN_ITEMS:assign multiple items
ASSIGN_MOBILE_USERS_TO_TEAMS
CHECK_IN: check-in on the mobile app
CHECK_OUT:check-out on the mobile app
CREATE_DASHBOARD: create dashboard
CREATE_ITEM: create a single item
CREATE_ITEMS:create multiple items
CREATE_LIST: create a single list
CREATE_MOB_USER:create a single mobile suer
CREATE_MOB_USERS: create multiple mobile users
CREATE_SUBMISSION:create a single submission
CREATE_TEAM: create a single team
CREATE_TEAMS: create multiple teams
CREATE_WEB_USER: create a single web user
CREATE_WEB_USERS:create multiple web users
CREATE_WORKFLOW: create a single workflow
DELETE_ITEM: delete a single item
DELETE_ITEMS: delete multiple items
DELETE_MOB_USER: delete a single mobile user
DELETE_MOB_USERS: delete multiple mobile users
DELETE_SUBMISSION:delete a submission
DELETE_TEAM: delete a single team
DELETE_TEAMS: delete multiple teams
DELETE_WEB_USER: delete a single web user
DELETE_WEB_USERS:delete multiple web users
EDIT_DASHBOARD: edit a single dashboard
EDIT_GPS: edit the gps coordinates in the place list
EDIT_ITEM: edit a single item
EDIT_ITEMS:edit multiple items
EDIT_LIST: edit a list
EDIT_MOB_USER:edit a single mobile user
EDIT_MOB_USERS:edit multiple mobile users
EDIT_SUBMISSION: edit a single submission
EDIT_TEAMS: edit a single team
EDIT_TEAMS: edit multiple teams
EDIT_WEB_USER: edit a single web user
EDIT_WORKFLOW: edit a single workflow
LICENSE_MOB_USER: license a single mobile user
LICENSE_MOB_USERS: license multiple mobile users
LOGIN: the user has logged in
OTP: an OTP has been requested by the user
RESET_PASSWORD: reset the web user password on the profile module
RESTORE_ITEM:restore a single archived item
RESTORE_ITEMS: restore multiple archived items
RUN_DASHBOARD: open the dashboard or apply some filters on a dashboard
RUN_STREAM: run a stream
UNLICENSE_MOB_USER: unlicense a single mobile user
UNLICENSE_MOB_USERS: unlicense multiple mobile users
UPLOAD_FILE_FOR_ITEM: have an attachement for an item, for example a picture for an item in a list
UPLOAD_FILE_FOR_SUBMISSION: have an attachement for a submission, for example a picture for a workflow question
UPLOAD_FILE_FOR_WORKFLOW: have an attachement for a workflow, for example a picture for a workflow

More details here

status

text

The main options are:

  • ERR: The action has not been proceeded successfully

  • SUCC: The action has been successfully made

  • NALW: The user is not allowed to do this action, the user does not have enough rights, or the action is not possible to do

  • NUTD: The resource is not up to date and the user needs to sync before doing this action. For example, if the item has been modified on the webapp and the user has not sync yet.

  • RIBG: Run in Background

  • PSUC: The action has been partially completed (for example when there is bulk operation, only a few items have been edited/created/… successfully)

  • ITOP: Invalid OTP

  • UNFD: The user (who is trying to do the action) not found

  • LNVD: The mobile user license is not valid

  • TCHG: The team has changed and the user needs to sync

  • ALGI : The user is already logged in

More details here

response

text

More details on the response.
It can be useful when the status='ERR' to get more information on the issue.

workflow_id

text

Workflow id when the action_code is related to a workflow (For example for action_code=CREATE_SUBMISSION or EDIT_SUBMISSION or CREATE_WORKFLOW or EDIT_WORKFLOW)

=workflows.id

dashboard_id

text

Dashboard_id when the action_code is related to a dashboard (For example for action_code=CREATE_DASHBOARD or EDIT_DASHBOARD or RUN_DASHBOARD)

=dashboards.id

list_id

text

Submission_id when the action_code is related to a list (For example for action_code=CREATE_SUBMISSION or EDIT_SUBMISSION)

=lists.id

place_id

text

Submission_id when the action_code is related to a place (For example for action_code=CHECK_IN or CHECK_OUT)

=l_place._id

submission_id

text

Submission_id when the action_code is related to a submission (For example for action_code=CREATE_SUBMISSION or EDIT_SUBMISSION)

=w_<workflowid>._id

data

text

The data that has been submitted. For example, the submission data when the action_code is related to a submission

old_data

text

The data that has been replaced when there is an edition. For example, the old data when the action_code is related to an item edit

visit_id

text

The visit_id is a key to gather all the actions made between a CHECK_IN and a CHECK_OUT
It will be the same for:
1. The check-in (action_code=CHECK_IN)
2. All the submissions made (action_code=CREATE_SUBMISSION)
3. The check-out (action_code=CHECK_OUT)

mobile_app_version

text

When the user_type='MOBILE', the version of the mobile app used at the time of the action