Page History

Panel

borderColor	green
borderWidth	1
titleBGColor	#ddffcc
borderStyle	solid
title	Definition	定义

高级表单行数据绑定器是表单数据绑定器的扩展版本。它允许您以引导和友好的方式添加 筛选条件。Advanced Form Row Data Binder is an extended version of the default 表单数据绑定器. It allows you to add in Filter Conditions in a guided and friendly manner.

Panel

borderColor	purple
borderWidth	1
titleBGColor	#ddccff
borderStyle	solid
title	New Feature	新功能

这个特性在Joget Workflow v6中得到了增强。This feature has been enhanced in Joget Workflow v6.

Figure 图 1: Advanced Form Data Binder Properties高级表单绑定器属性

名称

描述

表单

源表单来检索数据。

关联数据表

Name

Description

Form

Source form to retrieve data from.

Joins Form Data Table

Info

title	New Feature

This is a new feature in Joget Workflow v6.

新功能

这是Joget Workflow v6中的一个新功能。

名称	描述
表格数据表名称	目标表加入
领域	要加入的目标表格字段
加入字段ID	父字段标识加入
Name	Description
Form Data Table Name	Target table to join with
Field	Target table field to join with
Join Field Id	Parent field Id to join with

Info

title	Sample	样例

在图1的屏幕截图示例中，可以使用以下SQL来呈现这些配置。In the screenshot example in Figure 1, such configurations can be presented with the following SQL.

Code Block

language	sql
title	Sample SQL示例SQL

SELECT * FROM "Claim Entry" entry JOIN hr_expense_claim claim ON claim.id = entry.claim

Figure 图 2: Advanced Form Data Binder Properties - Advanced - Filter高级表格绑定器- 高级 - 过滤器

名称

描述

筛选条件

名称	描述
加入类型	并且或者
领域	字段ID。（如标题） Image Added
操作	等于不等于比...更棒大于或等于少于小于或等于喜欢不喜欢在不在是真的是假的一片空白不是空的
值	筛选值

附加条件

用于筛选数据集的附加条件。HQL是在这里预期的。

Info

title	语法查询

用e.customProperties开始你的筛选器名称。其次是字段ID（即标题）

Name

Description

Filter Conditions

Name	Description
Join Type	And Or
Field	Field ID. (e.g. title) Image Removed
Operator	Equal Not Equal Greater Than Greater Than Or Equal Less Than Less Than Or Equal Like Not Like In Not In Is True Is False Is Null Is Not Null
Value	Filter value

Extra Conditions

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

Info

title	Syntax Query

Start your filter name with e.customProperties. followed by the field id (i.e. title)

Info

title	HQL is accepted	HQL被接受

您甚至可以使用“LIKE”等操作符来缩小数据集。You may even use operator such as "LIKE" to narrow down your data set.

Code Block

title	Sample样例

e.customProperties.title = 'Trip'

Hash variable is accepted here.这里接受哈希变量。

Code Block

title	Sample样例

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

Userview Key can be used as part of the condition. 可以用作条件的一部分。

Code Block

language	sql
title	Sample样例

e.customProperties.category_id = '#userviewKey#'

Figure 图 3: Advanced Form Data Binder Properties - Advanced - Aggregate Query高级表单绑定器 - 高级 - 聚合查询

Info

title	New Feature

This is a new feature in Joget Workflow v6.

新功能

这是Joget Workflow v6中的一个新功能。

名称	描述
聚合字段	选择字段是汇总。计数不重复计数和最小最大平均在上面的示例截图中，“数量”字段将被放入“总和”功能，“计数”将被应用于“标题”。
Group By	将分组子句/功能添加到最终的数据集。这可以与上面的筛选条件一起使用。在上面的示例截图中，“金额”字段将由“索赔人”加总，显示在每个记录行中。
表达式列	HAVING子句使您能够指定在最终结果中显示的组结果的筛选条件。WHERE子句将条件放置在选定的列上，而HAVING子句将条件放置在GROUP by子句所创建的组中。
Name	Description
Aggregate Fields	Select field is to aggregated. Count Count Distinct Sum Min Max Avg In the sample screenshot above, the "amount" field will be put into the "Sum" function, and "Count" will be applied to "title".
Group By	Add grouping clause/function to the eventual data set. This can be used together with Aggregate Fields above. In the sample screenshot above, the "amount" field will be summed up by "claimant", shown in per record row.
Having Conditions	The HAVING clause enables you to specify conditions that filter which group results appear in the final results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on groups created by the GROUP BY clause. Read more at 阅读更多:http://www.dofactory.com/sql/having

The configurations shown in Figure 3 will produce the following sample result.图3中显示的配置将产生以下示例结果。

Figure 4: Sample result图4：示例结果

Page tree

Versions Compared

Old Version 1

New Version 2

Key