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
The option here This API is based on the current app context.

Image RemovedImage Added

Name

Description

1

List form data audit trails

Panel

borderColor	black
bgColor	#fbfff5
borderStyle	solid

List all

records present in the Audit Trail database table by default

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	/

auditTrails

formAuditTrails

HTTP Method

GET

Query String Parameters

Parameter	Description
search	Filters the response by querying the search terms

for username, java class, java method, or output message.

for:

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

Similar to the LIKE

condition

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

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.
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 5

New Version Current

Key