[1IM version 6.1.4 (soon to be 7.1), windows servers, MS SQL DB]
I am writing or trying to write a query that will find the current approver or approvers for a PWO/ITShop request.
I have kind of got a product Owner approval step working, but it is indeed complicated to address all types of approval steps.
Side info: My company uses a custom written website to allow workers to order products like Itshop items, instead of using the itshop website.
My co-workers are asking for a way to get the current approver for a request so it can be displayed and they can hunt them down.
If anyone wants my SQL code for the Product owner I will then post it here.
Thanks again, Todd fendt