You are viewing limited content. For full access, please sign in.

Question

Question

Forms Supervisor Drop downlist

Forms Layout Designer Forms Laserfiche
Updated April 2
asked on April 1

Has anyone had experience with populating a dropdown list in a form based on who has the supervisor role in Forms directory? We had been using it in 10.4 and just upgraded to 12 and SQL lookup table we had is no longer working. 

Here is the SQL Query in the view: 

SELECT        dbo.team_roles.id, dbo.team_member_team_role_mapping.team_role_id, dbo.team_member_team_role_mapping.team_member_id, dbo.team_members.id AS Expr1, dbo.team_members.id AS Expr3, 
                         dbo.cf_users.user_id AS Expr2, dbo.cf_users.displayname
FROM            dbo.cf_users INNER JOIN
                         dbo.team_members ON dbo.cf_users.user_id = dbo.team_members.id INNER JOIN
                         dbo.team_member_team_role_mapping ON dbo.team_members.id = dbo.team_member_team_role_mapping.team_member_id INNER JOIN
                         dbo.team_roles ON dbo.team_member_team_role_mapping.team_role_id = dbo.team_roles.id

 

0 0

Answer

SELECTED ANSWER
replied on April 2

I was able to resolve this with a little help from co-pilot. Here is the corrected sql view:

SELECT DISTINCT u.user_id, u.displayname
FROM            dbo.cf_users AS u INNER JOIN
                         dbo.team_members AS tm ON tm.user_group_id = u.user_id INNER JOIN
                         dbo.team_member_team_role_mapping AS tmr ON tm.id = tmr.team_member_id INNER JOIN
                         dbo.team_roles AS tr ON tmr.team_role_id = tr.id
WHERE        (tr.name = 'Supervisor') AND (tr.is_deleted = 0)

2 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...