Versions Compared

Old Version 8

changes.mady.by.user Justin

Saved on

compared with

New Version 9

changes.mady.by.user Justin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


NameDescription
1List form data audit trails
Panel
borderColorblack
bgColor#fbfff5
borderStylesolid

List all form events captured by the Form Data Audit Trail plugin for the current app.

Able to filter or sort the returned results via parameters.

Name

Description
URL/formAuditTrails
HTTP MethodGET
Query String Parameters
ParameterDescription
search

Filters the response by querying the search terms for:

  • form ID
  • table name
  • username of user performing such action
  • form action performed
  • form data contained

Similar to the LIKE condition for database querying.

dateFrom

Filters the response from the specified date and time.

Format: YYYY-MM-DD hh:mm:ss (e.g: 2019-08-26 00:00:00)

dateTo

Filters the response to the specified date and time.

Format: YYYY-MM-DD hh:mm:ss (e.g: 2019-08-27 23:59:59)

sort

Audit Form data audit trails data column to sort.

Must be used in conjunction with "sortDescending" parameter.

sortDescending

Sort the specified "sort" parameter value in ascending or descending order.

Expects a boolean value.

Must be used in conjunction with "sort" parameter.

startOffsetStarting position of records to start query. Expects an integer.
pageSizeNumber of results to return. Expects an integer.
Sample Response
Code Block
languagejs
[
  {
    "id": "d708f060-c0a86310-60e35ca0-2e253741",
    "appId": "expenseclaim",
    "appVersion": "1",
    "formId": "ExpensesClaim",
    "tableName": "j_expense_claim",
    "username": "admin",
    "action": "loadWithoutTransaction",
    "data": "141_expenseclaim_process1",
    "datetime": "Aug 28, 2019 2:03:03 PM"
  },
	.....
]

...