Versions Compared

Old Version 1

changes.mady.by.user Aadrian Zarin

Saved on

compared with

New Version Current

changes.mady.by.user Gabriel Wong

Saved on

Key

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

Table of Contents

Introduction

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

Image Added

Select the Form you wish to use.

Image AddedImage Removed

NameDescription
FormSource form to retrieve data from.
Extra Filter Condition

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

Info
titleSyntax Query
Start your filter name with e.customProperties. followed by the field id (i.e. username)
Image RemovedImage Added
Info
titleHQL is accepted

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

Image RemovedImage Added

Code Block
titleSample
e.customProperties.title = 'Trip'

A hash variable is accepted here.

Code Block
titleSample
e.customProperties.submitted_by = '#currentUser.id#'

Userview Key can be used as part of the condition.

Code Block
languagesql
titleSample
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)

Appears only when Cache Row Count? is checked. Defines the cache validity period in seconds (default: 3600). After expiry, a new count query is executed.