Introduction

Form Data List Data Store is the default data store used to return data from submitted forms.

Form Data List Data Store Properties

Click on Data and select Form Data.

Knowledge Base for DX 8 > Form Data List Data Store > select-form-data-binder.png

Select the Form you wish to use.

Knowledge Base for DX 8 > Form Data List Data Store > select-form.png

Name

Description

Form

Source form to retrieve data from.

Extra Filter Condition

Additional condition(s) for filtering the data set. HQL is expected here.

Start your filter name with e.customProperties. followed by the field id (i.e. username)
Knowledge Base for DX 8 > Form Data List Data Store > filter-name.png

Knowledge Base for DX 8 > Form Data List Data Store > filter-name.png

You may even use operator such as "LIKE" to narrow down your data set.

Knowledge Base for DX 8 > Form Data List Data Store > extra-filter-condition.png

e.customProperties.title = 'Trip'

A hash variable is accepted here.

e.customProperties.submitted_by = '#currentUser.id#'

Userview Key can be used as part of the condition.

e.customProperties.category_id = '#userviewKey#'

Cache Row Count?

Enables caching of row count queries to improve performance and reduce database load.

Cached Row Count TTL (seconds)

Defines the cache validity period in seconds (default: 3600). After expiry, a new count query is executed.