Question & Answer > View Question

How to allow only the HOD to only view their own department request

Confluence User - 01 Feb, 2021

Currently I have set up a datalist to allow the requestor to view their own request using the below filter
I would like to know how to allow the HOD to view their own respective section request only.

Example, HR can only view HR member request, while Finance can only view their own.

datalists;userviews

2

Confluence User •

01 Feb, 2021 •

confluenceUser •

•

confluenceUser •

Save the department id into the database when first time submitting the form record (you can use a hidden field with "#currentUser.department.id#") then use the Hash Variable#CurrentUserHashVariable to filter your datalist , example:

select * from app_fd_tableName where c_deptCode = "#currentUser.department.id#"

Reference: JDBC Datalist Database Binder

Confluence User •

02 Feb, 2021 •

confluenceUser •

•

confluenceUser •

If not mistaken the variable, '"#currentUser.department.id#" is not applicable for community version of joget, correct ?

If that is the case, then I am unable to perform as per your suggestion.

1

CSV | Excel | XML | PDF

Your answer

Print

How to allow only the HOD to only view their own department request

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-9ede3037-b0be-4964-8633-8894b82043a7{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-d2f5cb92-015c-4aec-86f3-1b78b6731140{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer