Thu, 24 Sep 2026
Login

Joget grouping column multiple value

Confluence User - 11 Feb, 2020

Hi!

I have table with Employees and Departments. Employee can work in several departments, so my Employees form has selectbox with multiple selection allowed. So data in Employees stored like  "User1   Department1; Department2; Department3"

And I have another form where I want to group columns by users in department, so I have 2 selectbox - in first one I choose department and in second one I want to see only users from specific department.  It works with users who has only 1 department, but it does not with users, who have several departments.  I tried to do it via extra filters, but didn't figured out. Can you please help me?

forms;grouping

2

Confluence User •
12 Feb, 2020 •
confluenceUser •
1 •
confluenceUser •

Maybe you could use a Form Grid for the department selection and use Multirow to store the user's department in a child database table (one user record to many department records - parent child relationship). This way, you can easily filter the users in reverse.

Also look into using JDBC Options Binder to perform the db searching in your original design.

Confluence User •
21 Feb, 2020 •
confluenceUser •
•
confluenceUser •

Thanks! Multirow is great!

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print