frevvo Forums

Re: Sort Task List

2012-05-17T12:39:33Z

Currently there is no option to sort the task list in any other way.

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

Sort Task List

2012-05-16T17:30:43Z

It appears the task list is currently sorted by earliest submission (top) to latest submission (bottom). Is there a way to sort the list differently?

Re: Using Flows, but skipping a step within that Flow

2012-05-14T12:18:55Z

Please check this documentation to add pre-conditions to flow steps.

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

Using Flows, but skipping a step within that Flow

2012-05-11T19:42:52Z

I am writing a workflow for a customer that their structure looks like this:
-->Employee
-->Supervisor
-->Dept. Manager
   -->Chief Op. Office
   -->Exec. Dir.
   -->HR/Payroll

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;
}
}

Re: Repeat item business rules

2012-05-11T19:23:48Z

Thanks prajakta. Who knows how many times I have looked right past that one sentence. Thank you for the direct response. Sometimes you look at something so long that if it were a snake, as they say, it would have bitten me! Thanks again.

Re: Trying to Update Table from Form Java

2012-05-10T18:02:34Z

When you browse 'http://fortisdemo:8080/database/REQUISITION/IncrementPurchaseRequisitionID' directly in the browser, you should see something the results of the select statement in your browser. That would indicate that the select statement is working.

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\tomcat\logs\catalina.xxxx-xx-xx.log after you browse the above url. It will show errors if any.

Re: Trying to Update Table from Form Java

2012-05-10T16:04:08Z

configuration.xml matches your post

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.

Re: Repeat item business rules

2012-05-10T15:30:39Z

If you have a repeating control in a form that itself contains a repeating control, you cannot apply a rule to the "inner" repeating control, since there's no way to tell which of the inner repeating items goes with which outer repeating item.

See this documentation.

Re: Repeat item business rules

2012-05-10T13:40:42Z

Following your specific instructions outside of an embedded repeat, it works. Without changing the code, I embed the items into the actual vendor repeat (repeat within a repeat), and it gives the above referenced error. Can I embed a repeat inside another one? And if so, does the code change to reflect this?

Re: Multiple Parameter select query syntax?

2012-05-09T14:49:17Z

You will need to use '&' to separate parameter values and '.value' is missing after the control names in the URL.

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

Re: Trying to Update Table from Form Java

2012-05-09T14:35:57Z

I did some experiments with this here, and it looks like the database connector is expecting a result set as a result. So, if there is nothing to return from your stored procedure you could return an empty set.

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:

      
        
             
                exec IncrementPurchaseRequisitionID

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

Multiple Parameter select query syntax?

2012-05-08T18:34:44Z

I am trying to get data from a table, but it requires sending two parameters. It does not return anything. I have queries in the same Javascript with one parameter that work fine.

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



   SELECT * FROM ChartofAccounts WHERE FundID = '{FundID}'
   AND ResPrj = '{ResPrj}'

Re: Trying to Update Table from Form Java

2012-05-08T18:20:06Z

The stored procedure is doing it's processing internally to SQL, and returning a value, why should frevvo care what it does as long as it returns something? The Configuration.xml has no idea what the stored procedure is doing.... Do I have to return a parameter in order to get an XML generated as a result?

Re: Trying to Update Table from Form Java

2012-05-08T17:49:55Z

Your stored procedure has Select as well as Update statements. The DB Connector will not work for it.

Since you are calling the SP in a 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.

Re: Trying to Update Table from Form Java

2012-05-08T17:17:06Z

I get a blank screen when using the "direct in browser" screen. Confirmed other select queries work. Stored procedure follows. I suspect that since there are no parameters, (except the return value) that is causing issues. IN SQL Query window, I get correct value returned.

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