Page History

...

A plugin named "Database Query Process Tool" is also bundled together as a utility for loading records.

...

For example:-

id

id

Name

Description

Iterator Method

Method to load the dataset.
Choose to load records either by using a Process Tool or from Datalist

List

Choose list to retrieve dataset from.
This option is needed when "Iterator Method" is set to "Datalist".

Iterator Process Tool

Choose a process tool to retrieve the dataset from.

Process Tool must return a collection of map as dataset.

Code Block

language	java
title	Sample Bean Shell Code
linenumbers	true

import org.joget.commons.util.LogUtil;
import java.util.Collection;
import java.util.Map;

Collection col = new ArrayList();

Map map = new HashMap();
map.put("id", "1");
map.put("name", "Alice");
col.add(map);

map = new HashMap();
map.put("id", "2");
map.put("name", "George");
col.add(map);

return col;

You may use "Database Query Process Tool" bundled with this plugin to enter a SQL query string.
This option is needed when "Iterator Method" is set to "Process Tool".

Record ID

Specify which column to be used as record ID / primary key from the dataset.

Code Block

language	java
title	Example
linenumbers	true

Execute Process Tool

Name

Description

Process Tool

With the dataset loaded, the plugin will iterate through each record and set the record or assignment as the context, and execute the process tool defined here.
In the plugin configuration, when using hash variable, instead of using # to encapsulate, please replace # with $$ in your plugin for parsing to take place in the correct context. For examples:-
- Assignment mode, use $$form.request.name$$.
  Code Block
  language java
  title Example
  linenumbers true
  $$form.request.name$$
- Record mode, use $$form.request.name[@recordId@]$$.
  Code Block
  language java
  title Example
  linenumbers true
  $$form.request.name[@recordId@]$$
- Retrieve values from iterator's dataset, use {columnName}.
  Code Block
  language java
  title Example
  linenumbers true
  {id}
  Code Block
  language java
  title Example
  linenumbers true
  {name}

...

Space shortcuts

Page tree

Versions Compared

Old Version 10

New Version Current

Key

Execute Process Tool