Page History

Panel

borderColor	green
borderWidth	1
titleBGColor	#ddffcc
borderStyle	solid
title	Definition

Form Audit Trail API will list all records present in form events captured by the Form Data Audit Trail plugin for the current app.

This API must be used in conjunction with the Form Data Audit Trail plugin via Plugin Default Properties.

...

.

Note
This API is based on the current app context.

Image Added

Name

Description

1

List form data audit trails

Panel

borderColor	black
bgColor	#fbfff5
borderStyle	solid

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 Method

GET

Query String Parameters

Parameter	Description
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 operator 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	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.
startOffset	Starting position of records to start query. Expects an integer.
pageSize	Number of results to return. Expects an integer.

Sample Response

Code Block

language	js

[
  {
    "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"
  },
	.....
]

Space shortcuts

Page tree

Versions Compared

Old Version 3

New Version Current

Key