Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
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
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.
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.