Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColorgreen
borderWidth1
titleBGColor#ddffcc
borderStylesolid
titleDefinition定义

高级表单行数据绑定器是 表单数据绑定器的扩展版本  。它允许您以 引导和友好的方式添加  筛选条件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
borderColorpurple
borderWidth1
titleBGColor#ddccff
borderStylesolid
titleNew Feature新功能

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

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

名称描述
表单源表单来检索数据。
关联数据表
NameDescription
FormSource form to retrieve data from.
Joins Form Data Table
Info
titleNew Feature

This is a new feature in Joget Workflow v6.

新功能

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

名称描述
表格数据表名称目标表加入
领域要加入的目标表格字段
加入字段ID父字段标识加入
NameDescription
Form Data Table NameTarget table to join with
FieldTarget table field to join with
Join Field IdParent field Id to join with
Info
titleSample样例

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

Code Block
languagesql
titleSample 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(即标题
NameDescription
Filter Conditions

Filter Conditions

NameDescription
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
ValueFilter value
Extra Conditions

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

Info
titleSyntax Query
Start your filter name with e.customProperties. followed by the field id (i.e. title)
Info
titleHQL is acceptedHQL被接受

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

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

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#'

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

Info
titleNew Feature

This is a new feature in Joget Workflow v6.

新功能

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

名称描述
聚合字段

选择字段是汇总。

  • 计数
  • 不重复计数
  • 最小
  • 最大
  • 平均

在上面的示例截图中,“数量”字段将被放入“总和”功能,“计数”将被应用于“标题”。

Group By

分组子句/功能添加到最终的数据集。这可以与上面的筛选条件一起使用。

在上面的示例截图中,“金额”字段将由“索赔人”加总,显示在每个记录行中。

表达式列HAVING子句使您能够指定在最终结果中显示的组结果的筛选条件。WHERE子句将条件放置在选定的列上,而HAVING子句将条件放置在GROUP by子句所创建的组中。
NameDescription
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 ConditionsThe 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:示例结果