Thu, 24 Sep 2026
Login

Datalist Filter Error

Confluence User - 15 Dec, 2022

Hii There,

Am Facing issue on datalist i have joined two tables with two filters its working fine some and  gives error table is not mapped sometime when i trigger approval process. Please check below snaps any help will be highly appreciated.


datalists;join;filters

1

Confluence User •
16 Dec, 2022 •
confluenceUser •
•
confluenceUser •

Map the datalist "id" to the process that's linked to the database table. For example, if app_fd_table1 is the process table, when using JDBC SQL datasource, type as (example):


SELECT a.id as id FROM app_fd_table1 a
LEFT JOIN b.id FROM app_fd_table2 b ON a.id=b.c_fkey

Then set the "Datalist Builder > Source > Primary Key" as "id" property. Meaning you need to pass the correct primary key "id" value of the process form you are accessing in Datalist Inbox.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
How to customize datalist process formatter
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?
I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?
List Question
Create Folder on the Home Page
Async search list with ajax
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print