Hash variable with filter or where

 
1
0
-1

If I have the below table of name app_fd_classes and using #currentUser.groups.id# to check the logged-in user group (suppose each user must be in one group) 

Class IDClass NameGroup ID
4class fourG-001
6class sixG-002

Can I have a hash variable that retrieves the class name of the currently logged-in user

Ex: If the logged-in user is in group 'G-001' then I want a hash variable to retrieve 'class four'

something like: #form.classes.ClassName[GroupId={currentUser.groups.id}]#


thanks in advance


  1. sushidetest

    have you figured this out? i have the same issue.

  2. Ian

    there's actually a new hash variable in jogetoss...might be what you're looking for GitHub - jogetoss/column-search-hash-variable

CommentAdd your comment...

1 answer

  1.  
    1
    0
    -1

    Form Data Hash variables only accept primary key though. You could use Datalist Hash Variable instead, it has filters.

    Hash Variable - Knowledge Base for DX 7 - Joget | COMMUNITY

    or

    do something like 

    Add Extra Attributes and Signature to User Profile - Knowledge Base for DX 7 - Joget | COMMUNITY

    add a selectbox (field id: class) looking up your classes table in your user profile (form id:user_profile). Then use Form Binder Hash VariableHash Variable - Knowledge Base for DX 7 - Joget | COMMUNITY

    #binder.options.classes.name[{form.user_profile.class[{currentUser.username}]}]#

      CommentAdd your comment...