Hi Hugo

Seek your kind assistance.

How do I set the "Extra Filter Condition" in Select Box to filter the DB based on an earlier value?

(Tab is the third one in "Edit Select Box > Choose Options Binder > Select Form")

Example:

1st Select Box user picks the company name.

2nd Select Box user picks the contact person based on all the contact person from the first Select Box above.

So the 2nd Select Box needs to filter and set "where <1st.selected.company.id> = <db.table_contact.clientId>'

How do i represent this in the "Extra Filter Condition"?

Thank you

  • No labels

4 Comments

  1. Hugo

    Hi Andrew,

    Thanks for posting in Joget forum. Currently, there's no way to achieve this by only using Joget alone. You will need to write your own scripting to tie onChange event on the first selectbox and populate the second selectbox.

    This is definitely one of the most commonly use case and we will take it into consideration on our product development road map.

    Thanks.

    Hugo

  2. Gideon Praveen

    Hi,

    Any solution for the above, as two years have passed after this question is raised.

    Also how do I use DISTINCT in extra filter condition to load a select box with unique values of a particular column.

    Thanks,

    Gideon.

    1. Gideon Praveen

      I got the answer to my question to use DISTINCT in extra filter condition.

      I used GROUP BY.

      customProperties.field=customProperties.field  GROUP BY customProperties.field

      customProperties.field=customProperties.field => some always true condition

      Thanks,

      Gideon

      1. Natdanai Toolsungnoen

        Please Examble config in joget 
        Thank you