Hi Raj,

Thanks,

Let me know any customization for the reference.

Thanks,

Madhu

Hi Madhu

We used DB queries to pull the data. Then grouped it by user and notified them. No SDK. One additional good thing that came out. While doing this, we were able to identify users who just left the company and notify CM of their pending approval notifications. This was a hold earlier and we were able to address it with this approach

Thanks Raj,

Its helpful.

Hi Raj,

Can you please let me know , which table i need to refer to pull user data in agile database.

Thanks,

Madhu

Hi Raj,

Can please share the query.

Thanks,

Madhu

Hi madhu

Here is a sample query

select c.”ID”,c.”CLASS”,c.”SUBCLASS”,c.”CHANGE_NUMBER”,c.”CATEGORY”,c.”STATUS”,c.”REASON_CODE”,c.”ORIGINATOR”,c.”OWNER”,
c.”CREATE_DATE”,c.”RELEASE_DATE”,c.”DESCRIPTION”,c.”REASON”,c.”MODIFYDATE”,c.”OBJVERSION”,c.”DELETE_FLAG”,c.”SUBMIT_DATE”,c.”ROUTE_DATE”,c.”PRODUCT_LINES”,c.”FLAGS”,c.”WORKFLOW_ID”,c.”STATUSTYPE”,c.”FINALCOMPLETE_DATE”,c.”PROCESS_ID”,c.”IN_REVIEW”,s.signoff_status, s.user_assigned, s.user_name_assigned, ch.timestamp, 0, null, null, trunc(sysdate – route_date)
from agile.signoff s join change c on c.process_id=s.process_id join agile.change_history ch on ch.id=s.history_id left outer join agile.agileuser a on s.user_assigned = a.id
left outer join agile.agileuser cm on c.owner = cm.id
where c.statustype = 2 and s.signoff_status = 0

– Raj

Thank you Raj.

ITable wfTable = change.getTable(“Workflow”);
ITwoWayIterator tableIter = wfTable.getTableIterator();
while(tableIter.hasNext()) {
IRow row = (IRow) tableIter.next();
String str=row.getCell(“Signoff.Action”).getValue().toString();

Raj in the above,  i can read the  workflow Signoff.Action,

but while trying to read the Signoff. Local Client Time.  Getting an error through java code with main method.

Can i get any help on this which will be helpful.

What error are you getting? It should be just a java Date object. Please provide more details