Approver Notification

Hi, Can we send Approver notification frequently(Everyday) until they approve?   Thanks, Madhu

Agile User Asked on June 29, 2021 in Product Collaboration.
Add Comment
1 Answer(s)

Hi Madhu

Unfortunately, it is not possible via out of the box functionality. We had a similar requirement and we had to develop a custom solution for this

-Raj

 

Agile Angel Answered on June 29, 2021.

Hi Raj,

Thanks,

Let me know any customization for the reference.

Thanks,

Madhu

 

on June 30, 2021.

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

on June 30, 2021.

Thanks Raj,

Its helpful.

 

on July 1, 2021.

Hi Raj,

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

 

Thanks,

Madhu

on July 1, 2021.

Hi Raj,

Can please share the query.

Thanks,

Madhu

on July 1, 2021.

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

on July 2, 2021.

Thank you Raj.

on July 5, 2021.

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.

on July 5, 2021.

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

on July 6, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.