Posts: 163
Threads: 55
Joined: Apr 2016
Likes Received: 13 in 10 posts
Likes Given: 11
Country:
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.
•
Posts: 376
Threads: 0
Joined: Nov 2015
Likes Received: 34 in 33 posts
Likes Given: 1
Country:
(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.
•