Populate manager username in dynamic attribute based on the user selected in another dynamic attribute

[Community_User]

Originally posted on January 24 2019 at 17:05 UTC

Hi,

Is there a way to pre-populate the manager User ID in field 2 based on the user selected in field2

[Community_User]

Originally posted on January 25 2019 at 09:07 UTC

Example :

DynamicAttr1 is Enum type and Values, UserId1, UserId2, UserID3,....... and so on.

Then ,

DynamicAttr2 should be Single Select From SQL Query,

value - select username from users where userkey in (Select manager from users where username = '${DynamicAttr1 }')

[Community_User]

Originally posted on January 25 2019 at 15:51 UTC

Thanks for the response.

I get the below error: dynamic attribute name is userid

select username from users where userkey in (Select manager from users where username = '${userid}')

No such property: userid for class: SimpleTemplateScript2. Stacktrace follows:

org.codehaus.groovy.grails.web.pages.exceptions.GroovyPagesException: Error processing GroovyPageView: Error executing tag <g:render>: No such property: userid for class: SimpleTemplateScript2

at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53)

at grails.plugin.springsecurity.rest.RestAuthenticationFilter.doFilter(RestAuthenticationFilter.groovy:143)

at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62)

at grails.plugin.springsecurity.web.SecurityRequestHolderFilter.doFilter(SecurityRequestHolderFilter.java:59)

at com.mrhaki.grails.plugin.xframeoptions.web.XFrameOptionsFilter.doFilterInternal(XFrameOptionsFilter.java:69)

at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:82)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Caused by: org.codehaus.groovy.grails.web.taglib.exceptions.GrailsTagException: Error executing tag <g:render>: No such property: userid for class: SimpleTemplateScript2

at app_tomcat_apache_tomcat_8_5_29_webapps

[Community_User · Accepted solution]

Originally posted on April 30 2019 at 10:00 UTC

Please use below example :

DynamicAttr1 is Enum type and Values, UserId1, UserId2, UserID3,....... and so on.

Then ,

DynamicAttr2 should be Single Select From SQL Query,

Please use below value in DynamicAttr2 :

Value in DynamicAttr2 - Select username as ID from users where departmentname=${DynamicAttr1}

Also you have to mention Parent Attribute as DynamicAttr1

Regards,

Rakesh

[Community_User]

Originally posted on August 20 2019 at 11:43 UTC

How to specify the entire list of users in the Dynamic Attr1? A company would have more than 60K users.

[Community_User]

Originally posted on August 20 2019 at 11:49 UTC

Our requirement is to bring in the companyname attribute value from users table. How do we select company name for the selected user using dynamic attribute?