Hello GRC experts,
I have a query regarding DB lookup in BRF+. An agents rule have been created. I have a Z table which includes departments and their respective HoDs. There can be more then one HoD for a department.
So, using DB lookup, I want to fetch all the HoDs associated to a particular department and the result value(s) would be the approver agent(s) for one of the stages in MSMP.
Using multiple DB look up, it is possible to fetch single value of HoD for a department input value. But I am not able to fetch all values for HoDs of a department entry in Z table.
Your valuable suggestion are highly appreciated.
Thank you - Naveen