Skip to Content
0
Former Member
Sep 21, 2017 at 09:36 AM

BRF plus - Multiple result value from a db lookup

1636 Views Last edit Sep 27, 2017 at 04:00 AM 5 rev

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