Question & Answer > View Question

Hash variable with filter or where

Confluence User - 25 Aug, 2022

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 ID	Class Name	Group ID
4	class four	G-001
6	class six	G-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

forms;hash-variables;nested_hash_variables;filters

1

Confluence User •

26 Aug, 2022 •

confluenceUser •

•

confluenceUser •

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}]}]#

1

CSV | Excel | XML | PDF

Your answer

Print

Hash variable with filter or where

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

Hash variable with filter or where.builder-style-c7fae501-a94a-4299-9453-e9e387c08123{background: #efefef59 !important; margin: 0px !important; padding: 10px !important; border-radius: 5px !important; border: 1px solid #ddd !important; text-align: left !important; color:#0E4A40 !important;}

1.builder-style-7d46e731-e24f-45dd-9336-17c15283d0e3{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-02bad9b9-8b13-4930-84d6-bfd93c486c9c{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

Hash variable with filter or where

1

Your answer