Hi everyone!

Now, I'm trying to fill select box with users that had been assigned in the Group. For example, my group name is "Approval".

Below is my query:

("(SELECT  * FROM dir_user WHERE dir_group.name='Approval')");

My query fail to run. Is there any changes should I made?

Thanks.

  • No labels

2 Comments

  1. Owen Ong

    Hi Sarah,

    I believe your trying to write MySQL query in Bean Shell Plugin, right?

    Your query is not a valid MySQL query. It should be as below:

    select u.* from dir_user u join dir_user_group ug on ug.userid = u.id join dir_group g on g.id = ug.groupid where g.name = "Managers";

    Hope this's help.

    Regards,

    Owen

  2. aimi

    i run this query but its not work.