But you can search for any particular task in the History tab of the task list.

The steps will execute only if their pre-conditions are satisfied.

There are some employees that do not have a supervisor. So, they would skip that step in the flow and go directly to the Dept. Manager. Here is what I have so far. However, I have not been able to figure out how to get those w/out a supervisor to go ahead to the DM. Right now it just puts the DM into the supervisor section, thus throwing off the rest of the flow.

if (form.load)
{
current_date.value = DateUtil.today();
  var an = _data.getParameter ("flow.activity.name");
//Employee
  if (an == 'Employee' && EmployeeName.value.length == 0) {
EmployeeName.value = _data.getParameter('subject.first.name') + ' ' + _data.getParameter('subject.last.name');
    SId.value = _data.getParameter('subject.reports.to');
    ApprovalSection.visible = false;
    SupervisorApproval.visible = false;
    SupervisorApproval.required = false;
    ManagerApproval.visible = false;
    ManagerApproval.required = false;
    COOApproval.visible = false;
    COOApproval.required = false;
    ExecutiveApproval.visible = false;
    ExecutiveApproval.required = false;
    HRPayrollOnly.visible = false;
    HRPayrollOnly.required = false;
  }
//Supervisor
else if (an == 'Supervisor' && SupervisorName.value.length == 0) {
SupervisorName.value = _data.getParameter('subject.first.name') + ' ' + _data.getParameter('subject.last.name');
    MId.value = _data.getParameter('subject.reports.to');
    SupervisorApproval.visible = true;
    SupervisorApproval.required = true;
    ManagerApproval.visible = false;
    ManagerApproval.required = false;
    COOApproval.visible = false;
    COOApproval.required = false;
    ExecutiveApproval.visible = false;
    ExecutiveApproval.required = false;
    HRPayrollOnly.visible = false;
    HRPayrollOnly.required = false;
}
//Department Manager
else if (an == 'Manager' && ManagerName.value.length == 0) {
ManagerName.value = _data.getParameter('subject.first.name') + ' ' + _data.getParameter('subject.last.name');
    COOId.value = _data.getParameter('subject.reports.to');
    SupervisorApproval.visible = false;
    SupervisorApproval.required = false;
    ManagerApproval.visible = true;
    ManagerApproval.required = true;
    COOApproval.visible = false;
    COOApproval.required = false;
    ExecutiveApproval.visible = false;
    ExecutiveApproval.required = false;
    HRPayrollOnly.visible = false;
    HRPayrollOnly.required = false;
  }
//COO
  if (an == 'COO' && COOName.value.length == 0) {
COOName.value = _data.getParameter('subject.first.name') + ' ' + _data.getParameter('subject.last.name');
    EDId.value = _data.getParameter('subject.reports.to');
    SupervisorApproval.visible = false;
    SupervisorApproval.required = false;
    ManagerApproval.visible = false;
    ManagerApproval.required = false;
    COOApproval.visible = true;
    COOApproval.required = true;
    ExecutiveApproval.visible = false;
    ExecutiveApproval.required = false;
    HRPayrollOnly.visible = false;
    HRPayrollOnly.required = false;
}
//Executive Director
  if (an == 'Executive Director' && ExecutiveDirName.value.length == 0) {
ExecutiveDirName.value = _data.getParameter('subject.first.name') + ' ' + _data.getParameter('subject.last.name');
    HId.value = _data.getParameter('subject.reports.to');
    SupervisorApproval.visible = false;
    SupervisorApproval.required = false;
    ManagerApproval.visible = false;
    ManagerApproval.required = false;
    COOApproval.visible = false;
    COOApproval.required = false;
    ExecutiveApproval.visible = true;
    ExecutiveApproval.required = true;
    HRPayrollOnly.visible = false;
    HRPayrollOnly.required = false;
}
//HR & Payroll
else if (an == 'HR' && HrName.value.length == 0) {
HrName.value = _data.getParameter('subject.first.name') + ' ' + _data.getParameter('subject.last.name');
    SupervisorApproval.visible = true;
    SupervisorApproval.required = true;
    ManagerApproval.visible = true;
    ManagerApproval.required = true;
    COOApproval.visible = true;
    COOApproval.required = true;
    ExecutiveApproval.visible = true;
    ExecutiveApproval.required = true;
    HRPayrollOnly.visible = true;
    HRPayrollOnly.required = true;
  }
}

So currently it looks like the SELECT is your SP is not returning anything. When you run the SP in a SQL window, do you see any results there?

You might want to look at the logs in <frevvo-install-dir>\frevvo\tomcat\logs\catalina.xxxx-xx-xx.log after you browse the above url. It will show errors if any.

I added the select statement following the rest of the SP code.

I tried returning @NewIDNUM, and also returning nothing (no return *** statement).

The browser test returns a blank page, the java script returns
unexpected end of file from the
eval('i=' + http.get('http://fortisdemo:8080/database/REQUISITION/IncrementPurchaseRequisitionID'));
statement.

See this documentation.

Your rule should have:
eval('f=' + http.get('http://fortisdemo:8080/database/REQUISITION/AccountsGivenFundAndResource?FundID=' + FundPicked.value + '&ResPrj=' + ResourcePicked.value)) ;

Adding a select statement at the end of your stored procedure should solve this problem for you.

Modify the stored procedure to:

ALTER PROCEDURE [dbo].[IncrementPurchaseRequisitionID] 
AS
BEGIN
    SET NOCOUNT ON;
DECLARE @ExistingID varchar(7)
DECLARE @NewID varchar(7)
DECLARE @NewIDNUM int
SELECT @ExistingID = Next_Purchase_Requisition_ID from Purchase_Requisition_ID;
SET @NewIDNUM = CONVERT(int,@ExistingID) + 1;
SET @NewID = CONVERT(varchar, @NewIDNUM);
    UPDATE Purchase_Requisition_ID set
    Next_Purchase_Requisition_ID = @NewID;
SELECT @ExistingID = Next_Purchase_Requisition_ID from Purchase_Requisition_ID;
END

No need of return statement, instead add any select statement. You may not use the result set, but it is necessary for the SP to work from the connector.

Also your query should be:

      <query name="IncrementPurchaseRequisitionID">
        <retrieve>
            <statement> 
                exec IncrementPurchaseRequisitionID
            </statement>
        </retrieve>
    </query>

Adding () or dbo. in it will cause errors.

In the Java script (FundPicked and ResourcePicked are string variables)
eval('f=' + http.get('http://fortisdemo:8080/database/REQUISITION/AccountsGivenFundAndResource?FundID=' + FundPicked + '?ResPrj=' + ResourcePicked)) ;

in configuration.xml
<query name="AccountsGivenFundAndResource" autocreate="true">
          <retrieve>
              <statement>
                  SELECT * FROM ChartofAccounts WHERE FundID = '{FundID}'
                  AND ResPrj = '{ResPrj}'
              </statement>
          </retrieve>
      </query>

Since you are calling the SP in a <retrieve> parameter, its goal is to only do the GET (i.e. Select) operation.

The SP will work if you remove the Update statement in it.

You will need to use Doc Actions to do any kind of Update/Create (PUT/POST) operation.

LTER PROCEDURE [dbo].[IncrementPurchaseRequisitionID]
AS
BEGIN
    SET NOCOUNT ON;

DECLARE @ExistingID varchar(7)
DECLARE @NewID varchar(7)
DECLARE @NewIDNUM int

SELECT @ExistingID = Next_Purchase_Requisition_ID from Purchase_Requisition_ID;
SET @NewIDNUM = CONVERT(int,@ExistingID) + 1;
SET @NewID = CONVERT(varchar, @NewIDNUM);
    UPDATE Purchase_Requisition_ID set
    Next_Purchase_Requisition_ID = @NewID;
return @NewIDNUM ;
END