• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

Custom Group
#1
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?
jhendrix, proud to be a member of EV CONNECT FORUM since Apr 2016.

#2
(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
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#3
At EV wiki you have nested sets info

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






Users browsing this thread: 1 Guest(s)