<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[frevvo Forums]]></title>
		<link>http://forum.frevvo.com/forum/index.php</link>
		<description><![CDATA[The most recent topics at frevvo Forums.]]></description>
		<lastBuildDate>Wed, 16 May 2012 17:30:43 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Sort Task List]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3794&amp;action=new</link>
			<description><![CDATA[<p>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?</p>]]></description>
			<author><![CDATA[null@example.com (saralemp)]]></author>
			<pubDate>Wed, 16 May 2012 17:30:43 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3794&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Using Flows, but skipping a step within that Flow]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3791&amp;action=new</link>
			<description><![CDATA[<p>I am writing a workflow for a customer that their structure looks like this:<br />--&gt;Employee<br />&nbsp; &nbsp; &nbsp;--&gt;Supervisor<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt;Dept. Manager<br />&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; --&gt;Chief Op. Office<br />&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;--&gt;Exec. Dir.<br />&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt;HR/Payroll</p><p>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. </p><p>if (form.load) <br />{<br />current_date.value = DateUtil.today();<br />&nbsp; var an = _data.getParameter (&quot;flow.activity.name&quot;);<br />//Employee<br />&nbsp; if (an == &#039;Employee&#039; &amp;&amp; EmployeeName.value.length == 0) {<br />EmployeeName.value = _data.getParameter(&#039;subject.first.name&#039;) + &#039; &#039; + _data.getParameter(&#039;subject.last.name&#039;);<br />&nbsp; &nbsp; SId.value = _data.getParameter(&#039;subject.reports.to&#039;);<br />&nbsp; &nbsp; ApprovalSection.visible = false;<br />&nbsp; &nbsp; SupervisorApproval.visible = false;<br />&nbsp; &nbsp; SupervisorApproval.required = false;<br />&nbsp; &nbsp; ManagerApproval.visible = false;<br />&nbsp; &nbsp; ManagerApproval.required = false;<br />&nbsp; &nbsp; COOApproval.visible = false;<br />&nbsp; &nbsp; COOApproval.required = false;<br />&nbsp; &nbsp; ExecutiveApproval.visible = false;<br />&nbsp; &nbsp; ExecutiveApproval.required = false;<br />&nbsp; &nbsp; HRPayrollOnly.visible = false;<br />&nbsp; &nbsp; HRPayrollOnly.required = false;<br />&nbsp; } <br />//Supervisor<br />else if (an == &#039;Supervisor&#039; &amp;&amp; SupervisorName.value.length == 0) {<br />SupervisorName.value = _data.getParameter(&#039;subject.first.name&#039;) + &#039; &#039; + _data.getParameter(&#039;subject.last.name&#039;);<br />&nbsp; &nbsp; MId.value = _data.getParameter(&#039;subject.reports.to&#039;);<br />&nbsp; &nbsp; SupervisorApproval.visible = true;<br />&nbsp; &nbsp; SupervisorApproval.required = true;<br />&nbsp; &nbsp; ManagerApproval.visible = false;<br />&nbsp; &nbsp; ManagerApproval.required = false;<br />&nbsp; &nbsp; COOApproval.visible = false;<br />&nbsp; &nbsp; COOApproval.required = false;<br />&nbsp; &nbsp; ExecutiveApproval.visible = false;<br />&nbsp; &nbsp; ExecutiveApproval.required = false;<br />&nbsp; &nbsp; HRPayrollOnly.visible = false;<br />&nbsp; &nbsp; HRPayrollOnly.required = false;<br />}<br />//Department Manager<br />else if (an == &#039;Manager&#039; &amp;&amp; ManagerName.value.length == 0) {<br />ManagerName.value = _data.getParameter(&#039;subject.first.name&#039;) + &#039; &#039; + _data.getParameter(&#039;subject.last.name&#039;);<br />&nbsp; &nbsp; COOId.value = _data.getParameter(&#039;subject.reports.to&#039;);<br />&nbsp; &nbsp; SupervisorApproval.visible = false;<br />&nbsp; &nbsp; SupervisorApproval.required = false;<br />&nbsp; &nbsp; ManagerApproval.visible = true;<br />&nbsp; &nbsp; ManagerApproval.required = true;<br />&nbsp; &nbsp; COOApproval.visible = false;<br />&nbsp; &nbsp; COOApproval.required = false;<br />&nbsp; &nbsp; ExecutiveApproval.visible = false;<br />&nbsp; &nbsp; ExecutiveApproval.required = false;<br />&nbsp; &nbsp; HRPayrollOnly.visible = false;<br />&nbsp; &nbsp; HRPayrollOnly.required = false;<br />&nbsp; } <br />//COO<br />&nbsp; if (an == &#039;COO&#039; &amp;&amp; COOName.value.length == 0) {<br />COOName.value = _data.getParameter(&#039;subject.first.name&#039;) + &#039; &#039; + _data.getParameter(&#039;subject.last.name&#039;);<br />&nbsp; &nbsp; EDId.value = _data.getParameter(&#039;subject.reports.to&#039;);<br />&nbsp; &nbsp; SupervisorApproval.visible = false;<br />&nbsp; &nbsp; SupervisorApproval.required = false;<br />&nbsp; &nbsp; ManagerApproval.visible = false;<br />&nbsp; &nbsp; ManagerApproval.required = false;<br />&nbsp; &nbsp; COOApproval.visible = true;<br />&nbsp; &nbsp; COOApproval.required = true;<br />&nbsp; &nbsp; ExecutiveApproval.visible = false;<br />&nbsp; &nbsp; ExecutiveApproval.required = false;<br />&nbsp; &nbsp; HRPayrollOnly.visible = false;<br />&nbsp; &nbsp; HRPayrollOnly.required = false;<br />}<br />//Executive Director<br />&nbsp; if (an == &#039;Executive Director&#039; &amp;&amp; ExecutiveDirName.value.length == 0) {<br />ExecutiveDirName.value = _data.getParameter(&#039;subject.first.name&#039;) + &#039; &#039; + _data.getParameter(&#039;subject.last.name&#039;);<br />&nbsp; &nbsp; HId.value = _data.getParameter(&#039;subject.reports.to&#039;);<br />&nbsp; &nbsp; SupervisorApproval.visible = false;<br />&nbsp; &nbsp; SupervisorApproval.required = false;<br />&nbsp; &nbsp; ManagerApproval.visible = false;<br />&nbsp; &nbsp; ManagerApproval.required = false;<br />&nbsp; &nbsp; COOApproval.visible = false;<br />&nbsp; &nbsp; COOApproval.required = false;<br />&nbsp; &nbsp; ExecutiveApproval.visible = true;<br />&nbsp; &nbsp; ExecutiveApproval.required = true;<br />&nbsp; &nbsp; HRPayrollOnly.visible = false;<br />&nbsp; &nbsp; HRPayrollOnly.required = false;<br />}<br />//HR &amp; Payroll<br />else if (an == &#039;HR&#039; &amp;&amp; HrName.value.length == 0) {<br />HrName.value = _data.getParameter(&#039;subject.first.name&#039;) + &#039; &#039; + _data.getParameter(&#039;subject.last.name&#039;);<br />&nbsp; &nbsp; SupervisorApproval.visible = true;<br />&nbsp; &nbsp; SupervisorApproval.required = true;<br />&nbsp; &nbsp; ManagerApproval.visible = true;<br />&nbsp; &nbsp; ManagerApproval.required = true;<br />&nbsp; &nbsp; COOApproval.visible = true;<br />&nbsp; &nbsp; COOApproval.required = true;<br />&nbsp; &nbsp; ExecutiveApproval.visible = true;<br />&nbsp; &nbsp; ExecutiveApproval.required = true;<br />&nbsp; &nbsp; HRPayrollOnly.visible = true;<br />&nbsp; &nbsp; HRPayrollOnly.required = true;<br />&nbsp; }<br />}</p>]]></description>
			<author><![CDATA[null@example.com (erisaf)]]></author>
			<pubDate>Fri, 11 May 2012 19:42:52 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3791&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Multiple Parameter select query syntax?]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3778&amp;action=new</link>
			<description><![CDATA[<p>I am trying to get data from a table, but it requires sending two parameters.&nbsp; It does not return anything.&nbsp; I have queries in the same Javascript with one parameter that work fine.</p><p>In the Java script (FundPicked and ResourcePicked are string variables)<br />eval(&#039;f=&#039; + http.get(&#039;http://fortisdemo:8080/database/REQUISITION/AccountsGivenFundAndResource?FundID=&#039; + FundPicked + &#039;?ResPrj=&#039; + ResourcePicked)) ; </p><p>in configuration.xml<br />&lt;query name=&quot;AccountsGivenFundAndResource&quot; autocreate=&quot;true&quot;&gt;<br />&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;retrieve&gt;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;statement&gt;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;SELECT * FROM ChartofAccounts WHERE FundID = &#039;{FundID}&#039; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;AND ResPrj = &#039;{ResPrj}&#039;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;/statement&gt;<br />&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;/retrieve&gt;<br />&nbsp; &nbsp;&nbsp; &nbsp;&lt;/query&gt;</p>]]></description>
			<author><![CDATA[null@example.com (blavis)]]></author>
			<pubDate>Tue, 08 May 2012 18:34:44 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3778&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Trying to Update Table from Form Java]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3768&amp;action=new</link>
			<description><![CDATA[<p>I am trying to perform the following SQL update statement (excerpt from configuration.xml)<br />&nbsp; &lt;query name=&quot;NextRequisitionID&quot;&gt;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &lt;update&gt;<br />&nbsp; &nbsp; &nbsp; &nbsp; &lt;statement&gt; &lt;!-- maps to http PUT... put syntax unknown no idea yet how to do this--&gt;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; update &quot;Purchase_Requisition_ID&quot; set Next_Purchase_Requisition_ID =<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (select Next_Purchase_Requisition_ID from &quot;Purchase_Requisition_ID&quot;) + 1<br />&nbsp; &nbsp; &nbsp; &nbsp; &lt;/statement&gt;<br />&nbsp; &nbsp; &nbsp; &lt;/update&gt;<br />&nbsp; &nbsp; &lt;/query&gt;</p><p>What syntax should I use to call this from a Form rule?</p><p>eval(&#039;x=&#039; + http.put(&#039;http://servername:8080/database/REQUISITION/NextRequisitionID&#039;)); </p><p>does not work.</p>]]></description>
			<author><![CDATA[null@example.com (blavis)]]></author>
			<pubDate>Wed, 02 May 2012 17:45:55 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3768&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Repeat item business rules]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3766&amp;action=new</link>
			<description><![CDATA[<p>I am working within a custom form that is utilizing non-schema controls in a nested repeat. Basically, I have a vendor repeat with the vendor items nested into the vendor. So when the user wants to add multiple vendors to their requisition, that vendor&#039;s items remain with that vendor in it&#039;s section. </p><p>The nested elements work great. The item totals work wonderfully when adding multiple items. The part I am having trouble with is the &quot;itemRemoved&quot; business rule. </p><p>The &quot;Suggested Vendor Section&quot; errors with the following error:</p><p>11:28:04,950&nbsp; WARN RuleObserver:458 - Error evaluating rule [PA Purchase Request.Calc req total if removed]: Java class &quot;[Ljava.lang.Object;&quot; has no public instance field or method named &quot;itemRemoved&quot;. ([PA Purchase Request.Calc req total if removed]#2)</p>]]></description>
			<author><![CDATA[null@example.com (erisaf)]]></author>
			<pubDate>Tue, 01 May 2012 16:31:00 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3766&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[No LInked Forms]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3758&amp;action=new</link>
			<description><![CDATA[<p>I have opened up the Flow Designer, added a form to my flow, but the &quot;Linked icon does not appear on the form (the pencil to edit and red X to delete do appear).&nbsp; THis happens when I use an existing form or grab the new form.</p>]]></description>
			<author><![CDATA[null@example.com (blavis)]]></author>
			<pubDate>Fri, 20 Apr 2012 20:43:47 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3758&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Disabled Send button error trigger]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3756&amp;action=new</link>
			<description><![CDATA[<p>Hi</p><p>Is there a technique whereby an error message or alert can displayed to users who click on the Send button when not all the mandatory fields have been completed?</p><p>The Send button is set up as &#039;Enable if valid&#039; and the users are prompted to complete all fields marked as mandatory but I want to cater for those users who think that just hitting the Send button means the form has been submitted.</p><p>If the Send button is not enabled can you test for a trigger event when a user attempts to click it?</p><p>Seems a daft post but not half as daft as some of our users!</p><p>Thanks</p>]]></description>
			<author><![CDATA[null@example.com (jmayo65)]]></author>
			<pubDate>Fri, 20 Apr 2012 13:34:22 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3756&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Message Control Set With Date Control]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3744&amp;action=new</link>
			<description><![CDATA[<p>I am trying to set the following display message &quot;Your box will be destroyed on: (Date)&quot;. The date control has been set by the user in the first step of the workflow. In the second step of the workflow, I have coded this rule:</p><p>if (form.load){<br />message.value = &#039;Your box will be destroyed on:&#039; + date.value <br />}</p><p>I have discoverd that the date control cannot be set in the message control.&nbsp; It displays the default &quot;This is my message&quot; in testing. If I leave out the date.value the text string displays &#039;Your box will be destroyed on:&#039; . If I change the variable to different control in the form (like text) it displays fine. Is there a solution to get the date displayed in the message?</p>]]></description>
			<author><![CDATA[null@example.com (saralemp)]]></author>
			<pubDate>Thu, 19 Apr 2012 17:29:32 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3744&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Textarea Word Limit Pattern]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3743&amp;action=new</link>
			<description><![CDATA[<p>Hi All,<br />I tried to create a pattern that would force an error when the user entered more than 150 words. </p><p>This is what I tried: \b[\s,\.-:;]*{150}</p><p>But it is not working. I entered more than 150 words without an error</p><p>Does anyone else have any suggestions.</p>]]></description>
			<author><![CDATA[null@example.com (ssoule)]]></author>
			<pubDate>Tue, 17 Apr 2012 21:29:34 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3743&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[confluence 4/4.1/4.2 compatibility?]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3741&amp;action=new</link>
			<description><![CDATA[<p>When is frevo going to release a plugin that is compatible with confluence v 4/4.1/4.2?</p><p>It has been roughly 7 months since version 4.0 was released and this is holding up our upgrade to the current version.</p>]]></description>
			<author><![CDATA[null@example.com (hanpa01)]]></author>
			<pubDate>Mon, 16 Apr 2012 21:55:23 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3741&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Confirmation Screen]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3727&amp;action=new</link>
			<description><![CDATA[<p>Is there a way for a user to enter data on a form, submit the data, but be taken to a new screen/area where it displays the data the user just entered with a message that says something like &quot;Please review your selections&quot; and then the user can click &quot;My selections are correct&quot;, which would actually submit the data for the next step in the workflow, or click &quot;edit selections&quot; and be taken back to the original form?</p>]]></description>
			<author><![CDATA[null@example.com (saralemp)]]></author>
			<pubDate>Fri, 06 Apr 2012 16:55:15 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3727&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Date Format]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3725&amp;action=new</link>
			<description><![CDATA[<p>I have a date control field that I also reference in an e-mail as part of the workflow. Even though I have selected the date format as 07-26-2012 for this control, the format displays in the e-mail as 2012-7-26, why is this?</p>]]></description>
			<author><![CDATA[null@example.com (saralemp)]]></author>
			<pubDate>Fri, 06 Apr 2012 13:33:45 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3725&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Repeating Section]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3690&amp;action=new</link>
			<description><![CDATA[<p>I have a form with a repeating section with several text boxes. I can add sections clicking the + of course. So basic form is fine. I would like to create a rule to Automatically (on form load event) create X sections. The X will be a variable. So the form opens with for example 3 sections if X=3 etc.</p><p>Not sure how to do this. Perhaps someone has done this before or can someone point me in the right direction?</p><p>Many thanks!</p>]]></description>
			<author><![CDATA[null@example.com (Larry)]]></author>
			<pubDate>Thu, 05 Apr 2012 04:17:56 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3690&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Not retrieving data from query]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3689&amp;action=new</link>
			<description><![CDATA[<p>I have a query defined in the configuration.xml file and the following code in my form rule.&nbsp; I have verified that the data is retrieved by putting the following into a browser http://servername:8080/database/REQUISITION/LocationGivenID and getting</p><p>&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; standalone=&quot;no&quot; ?&gt; <br />- &lt;LocationGivenID xmlns=&quot;http://www.frevvo.com/database/LocationGivenID&quot;&gt;<br />- &lt;row xmlns=&quot;&quot;&gt;<br />&nbsp; &lt;Location&gt;742&lt;/Location&gt; <br />&nbsp; &lt;/row&gt;<br />- &lt;row xmlns=&quot;&quot;&gt;<br />&nbsp; &lt;Location&gt;742&lt;/Location&gt; <br />&nbsp; &lt;/row&gt;<br />&nbsp; &lt;/LocationGivenID&gt;</p><p>The following is an excerpt from the stdout log file&nbsp; (the Requisition_Number is a text box on the form).<br />15:48:19,303&nbsp; WARN RuleObserver:455 - Error evaluating rule [PUSD Purchase Requisition Form.Form Load Script]: Cannot set &#039;value&#039; as &#039;undefined&#039; (SourceFile#107)<br />if (form.load) {</p><p>eval(&#039;x=&#039; + http.get(&#039;http://servername:8080/database/REQUISITION/LocationGivenID&#039;)); <br />Requisition_Number.value = x.Location;<br />}<br />Since the query should be returning data, why does it look like x.Location is undefined?&nbsp; Do I have a syntax error?</p>]]></description>
			<author><![CDATA[null@example.com (blavis)]]></author>
			<pubDate>Tue, 03 Apr 2012 23:19:36 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3689&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Identifying failing form rule?]]></title>
			<link>http://forum.frevvo.com/forum/viewtopic.php?id=3670&amp;action=new</link>
			<description><![CDATA[<p>After updating Frevvo, I&#039;m getting following errors with some of the forms:</p><p>10:58:58,406 ERROR ConstantRules:228 - Unable to GET initial document from URL: http://&lt;URL_HERE&gt; Got: java.lang.NullPointerException</p><p>This is a GET query and it uses database connector to display data on the form.</p><p>It looks like one of the business rules on the form is failing (ConstantRules:228). Is there some way to identify which rule exactly is failing?</p><p>Regards,<br />Antti K.</p>]]></description>
			<author><![CDATA[null@example.com (Antti)]]></author>
			<pubDate>Mon, 26 Mar 2012 08:43:15 +0000</pubDate>
			<guid>http://forum.frevvo.com/forum/viewtopic.php?id=3670&amp;action=new</guid>
		</item>
	</channel>
</rss>

