paruvella: Workflow approval pending records from Ax User Login

[Blog bot]

Источник: http://paruvella.spaces.live.com/Blo...4DB0!534.entry
==============

The following example gives an idea about how we can see the Workflow approval pending records, from a particular user Login.

In this example, I want to know, which all the ProjProposal Invoice records are pending for workflow approval process from my login Id.

static void WFApprRecordsFromUser(Args _args)
{
  qbds, qbds1;
  qbr;
  query = new Query();
  qr;
  projProposalJour;
 ;

 qbds = query.addDataSource(tablenum(ProjProposalJour));
 qbds.clearRanges();
 qbds.clearLinks();

 qbds1 = qbds.addDataSource(tablenum(WorkflowWorkItemTable));
 qbds1.addLink(fieldnum(ProjProposalJour, RecId), fieldnum(WorkflowWorkItemTable, RefRecId));
 qbds1.addRange(fieldnum(WorkflowWorkItemTable, RefTableId)).value(QueryValue(tablenum(ProjProposalJour)));
 qbds1.addRange(fieldnum(WorkflowWorkItemTable, Status)).value(QueryValue(WorkflowWorkItemStatus::Pending));
 qbds1.addRange(fieldnum(WorkflowWorkItemTable, UserId)).value("santo");
 qbds1.joinMode(joinmode::ExistsJoin);

 qr = new QueryRun(query);

 while (qr.next())
 {
 projProposalJour = qr.getNo(1);
 print projProposalJour.RecId;
 }
 pause;
}

...



Источник: http://paruvella.spaces.live.com/Blo...4DB0!534.entry