1
0
-1

Dear Expert,

 

For my App, there will a setup for companies to assign their own respective groups.

Therefore, I have manually created the groups using JOGET screen. The groups and users are stored in dir_group and dir_user_group.

 

Now, in company setup, I have a field where user can choose the group.

But, when the group is chosen, I need to show the list of names.

 

May I know how is this possible?

I tried a simple way by using AJAX. But, seems like AJAX form is always null. In other words, values are not being populated in AJAX Subform.

 

I have tried both JBCD Binder for Group Select Box:

TRIAL 1 : 

select a.groupID,b.name
from dir_user_group a
, dir_group b
where a.groupID like 'frtt%'
and a.groupId = b.id;

TRIAL 2 : 

select b.id,b.name
from dir_group b
where b.id like 'frtt%';

 

 

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Andrew,

       

      Yes, this is what I wanted. But, I want the field to be read only.

      Example:

      When we select 'hrAdmin', Julia and Shasha's name should be listed as read only field. 

       

      1. Andrew

        Hi In the Select Box design properties, for readonly, just click on the checkbox to set the "Advanced Options > UI > Readonly" field to readonly.

      2. Shubana Vijaya Kumar

        Hi Andrew, As long as the field is set to readonly, the field will not be populated.

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Hi

      Kindly refer to the sample app below to display group names, and based on the group name, to display the respective user names in the next select box field, using JDBC Options plugin.

      I hope this is the solution you are looking for (smile).

      APP_29823244_group_user.jwa

        CommentAdd your comment...