[jhendrix]

We have a WF that needs to identify & email all users on a particular floor in a single office based upon the asset identified in the SR/IN.  

Does anyone know how we could do this?    

If not, our DBA would like to know if anyone knows how to navigate (read) the LFT/RGT fields in the AM_LOCATION table?

[ABBE Philippe]

(09-30-2019, 05:11 PM)jhendrix Wrote: We have a WF that needs to identify & email all users on a particular floor in a single office based upon the asset identified in the SR/IN.  

Does anyone know how we could do this?    

If not, our DBA would like to know if anyone knows how to navigate (read) the LFT/RGT fields in the AM_LOCATION table?

Hello,
You should create a custom role to notify users.

I think this role "employee of parent location" are :

Data : Employee
select employee_id from am_employee 
left outer join am_location as parent on parent.location_id=am_employee.location_id
left outer join am_location as child on parent.LFT<child.LFT and parent.RGT>child.RGT and parent.LEVEL=child.LEVEL-1
where child.location_id in (select location_id from am_asset where asset_id in (select asset_id from sd_request where request_id in (@ID@)))

Note : Create a new role "employee of grand-parent location" for deeper level

P.ABBE

[E.Gómez]

At EV wiki you have nested sets info

https://wiki.easyvista.com/xwiki/bin/vie...ested+sets