Set a Field as a Function of other fields

[Lacey McDonnell]

Unfortunately, the post function is not working as expected. I followed the wiki but I get the attached screenshot exception errors for the also attached values entered

This is currently messing up our Tempo Timesheets account reporting :(

[Fidel Castro Armario]

Hi Lacey,

Did the problem appear after upgrading to version 2.2.8? In affirmative case, which was your previous version of the plugin?

[Lacey McDonnell]

Unfortunately it happened with the previous version as well, 2.2.7 - I updated it to 2.2.8 thinking it would fix the parse error, but to no avail.

FULL ERROR: (ACE Insurance Company of Puerto Rico)ACESUPPORT :: PARSE ERROR : Encountered " "ACESUPPORT "" at line 1, column 1. Was expecting one of: "-" ... ... "(" ... "round" ... "floor" ... "ceil" ... "abs" ... "remainder" ... "sqrt" ... "cbrt" ... "random" ... "pow" ... "max" ... "min" ... "modulus" ... "log10" ... "log" ... "sin" ... "cos" ... "tan" ... "asin" ... "acos" ... "atan" ... "sinh" ... "cosh" ... "tanh" ... "toDegrees" ... "toRadians" ... "numberOfSelectedItems" ... "numberOfAvailableItems" ... "length" ... ... ... "previousValue" ... "second" ... "minute" ... "hour" ... "dayOfTheWeek" ... "dayOfTheMonth" ... "month" ... "year" ... "timePart" ... "datePart" ... "addDaysSkippingWeekends" ... "addTimeSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "addMonths" ... "addYears" ... "null" ... "toNumber" ... "stringToDate" ... "first" ... "last" ... "nthElement" ... "indexOf" ... "count" ... "numberOfRemoteIssueLinks" ... "sum" ... "avg" ... "(" ... ... "null" ... ... "null" ... "previousValue" ... "null" ... "previousValue" ... "null" ... "null" ... ... ... "(" ... "-" ... "toNumber" ... "round" ... "floor" ... "ceil" ... "abs" ... "sqrt" ... "random" ... "max" ... "max" ... "min" ... "min" ... "pow" ... "remainder" ... "modulus" ... "numberOfSelectedItems" ... "numberOfAvailableItems" ... "length" ... ... "second" ... "minute" ... "hour" ... "dayOfTheWeek" ... "dayOfTheMonth" ... "month" ... "year" ... "timePart" ... "datePart" ... "addMonths" ... "addYears" ... "addDaysSkippingWeekends" ... "addDaysSkippingWeekends" ... "addTimeSkippingWeekends" ... "addTimeSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "count" ... "count" ... "count" ... "numberOfRemoteIssueLinks" ... "first" ... "last" ... "nthElement" ... "avg" ... "sum" ... "previousValue" ... "stringToDate" ... "stringToDate" ... "indexOf" ... "indexOf" ... "indexOf" ... "indexOf" ... "log" ... "log10" ... "cbrt" ... "sin" ... "cos" ... "tan" ... "sinh" ... "cosh" ... "tanh" ... "asin" ... "acos" ... "atan" ... "toDegrees" ... "toRadians" ... "null" ... ... ... "(" ... "-" ... "toNumber" ... "round" ... "floor" ... "ceil" ... "abs" ... "sqrt" ... "random" ... "max" ... "max" ... "min" ... "min" ... "pow" ... "remainder" ... "modulus" ... "numberOfSelectedItems" ... "numberOfAvailableItems" ... "length" ... ... "second" ... "minute" ... "hour" ... "dayOfTheWeek" ... "dayOfTheMonth" ... "month" ... "year" ... "timePart" ... "datePart" ... "addMonths" ... "addYears" ... "addDaysSkippingWeekends" ... "addDaysSkippingWeekends" ... "addTimeSkippingWeekends" ... "addTimeSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "count" ... "count" ... "count" ... "numberOfRemoteIssueLinks" ... "first" ... "last" ... "nthElement" ... "avg" ... "sum" ... "previousValue" ... "stringToDate" ... "stringToDate" ... "indexOf" ... "indexOf" ... "indexOf" ... "indexOf" ... "log" ... "log10" ... "cbrt" ... "sin" ... "cos" ... "tan" ... "sinh" ... "cosh" ... "tanh" ... "asin" ... "acos" ... "atan" ... "toDegrees" ... "toRadians" ... "(" ... "previousValue" ... "first" ... "last" ... "nthElement" ... "(" ... "(" ... "(" ... "first" ... "last" ... "nthElement" ... "(" ... ... "null" ... ... "null" ... "previousValue" ... "null" ... "previousValue" ... "null" ... "null" ... ... ... "(" ... "-" ... "toNumber" ... "round" ... "floor" ... "ceil" ... "abs" ... "sqrt" ... "random" ... "max" ... "max" ... "min" ... "min" ... "pow" ... "remainder" ... "modulus" ... "numberOfSelectedItems" ... "numberOfAvailableItems" ... "length" ... ... "second" ... "minute" ... "hour" ... "dayOfTheWeek" ... "dayOfTheMonth" ... "month" ... "year" ... "timePart" ... "datePart" ... "addMonths" ... "addYears" ... "addDaysSkippingWeekends" ... "addDaysSkippingWeekends" ... "addTimeSkippingWeekends" ... "addTimeSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "count" ... "count" ... "count" ... "numberOfRemoteIssueLinks" ... "first" ... "last" ... "nthElement" ... "avg" ... "sum" ... "previousValue" ... "stringToDate" ... "stringToDate" ... "indexOf" ... "indexOf" ... "indexOf" ... "indexOf" ... "log" ... "log10" ... "cbrt" ... "sin" ... "cos" ... "tan" ... "sinh" ... "cosh" ... "tanh" ... "asin" ... "acos" ... "atan" ... "toDegrees" ... "toRadians" ... "null" ... ... ... "(" ... "-" ... "toNumber" ... "round" ... "floor" ... "ceil" ... "abs" ... "sqrt" ... "random" ... "max" ... "max" ... "min" ... "min" ... "pow" ... "remainder" ... "modulus" ... "numberOfSelectedItems" ... "numberOfAvailableItems" ... "length" ... ... "second" ... "minute" ... "hour" ... "dayOfTheWeek" ... "dayOfTheMonth" ... "month" ... "year" ... "timePart" ... "datePart" ... "addMonths" ... "addYears" ... "addDaysSkippingWeekends" ... "addDaysSkippingWeekends" ... "addTimeSkippingWeekends" ... "addTimeSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "subtractDatesSkippingWeekends" ... "count" ... "count" ... "count" ... "numberOfRemoteIssueLinks" ... "first" ... "last" ... "nthElement" ... "avg" ... "sum" ... "previousValue" ... "stringToDate" ... "stringToDate" ... "indexOf" ... "indexOf" ... "indexOf" ... "indexOf" ... "log" ... "log10" ... "cbrt" ... "sin" ... "cos" ... "tan" ... "sinh" ... "cosh" ... "tanh" ... "asin" ... "acos" ... "atan" ... "toDegrees" ... "toRadians" ... "(" ... "previousValue" ... "first" ... "last" ... "nthElement" ... "(" ... "(" ... "(" ... "first" ... "last" ... "nthElement" ...

[Fidel Castro Armario]

Can you, please, export your workflow as XML file and attach it to this issue?

[Lacey McDonnell]

Attached as requested :)

[Fidel Castro Armario]

It's very strange, since I'm not getting the error, as you can see in the screenshot:

Can you please try keeping only the first setting rule?

Try also the following simple setting rule:

(A)B

[Lacey McDonnell]

I still got the parse error. I only set the first option, being

(ACE Insurance Company of Puerto Rico)ACESUPPORT

[Fidel Castro Armario]

Please, try only the simplest setting rule:

(A)B

Please, try writing the right part of the setting rule in double quotes, i.e., "ACESUPPORT"

Try also inserting the a "Set a field as a function of other fields" post-function in another transition.

[Lacey McDonnell]

Well, (A)B worked, with other fields

I tried changing A back to customer; that worked

Had a brain fart and thought, what if it just doesn't like all caps? No one likes to be yelled at?

It worked : |

Why??

[Fidel Castro Armario]

Are you doing all those test in the same transition as before?

All characters in uppercase should work. Can you please try again?

Which version of JIRA are you using?

[Lacey McDonnell]

Same transition - BUT I forgot to change the second field back. I think that's the problem. The new account field doesn't like this post function at all.

So using all lowercase gets this error (with or without the space between "benitez" and "support" - I tried both)

changing the first b of "benitezsupport" to B results as the same very, very long parse error Encountered " "Benitezsupport "" at line 1, column 1. etc etc

Adding quotes just does the same thing, only it's saying "Encountered " "\"" "\" "" at line 1, column 1. Was expecting one of:"

I then tried it on another transition; same error. It seems to be the Tempo Account field that refuses to be read.

[Lacey McDonnell]

Whoop. Got it.

I need the numerical value.

https://bitbucket.org/fcarmario/jira-workflow-toolbox/wiki/post-functions/Copy%20Parsed%20Text%20to%20a%20Field.wiki

[Lacey McDonnell]

I just looked up the database value combining the two Tempo tables needed; I have replaced all values with their numerical DB values. The parse worked; I created a few test issues and accounts is now mapping properly. Yay!

Thank you : )

[Fidel Castro Armario]

Great, Lacey.

Anyway, I will investigate why that parsing error is shown simply for selecting the wrong data type for the field.

[Fidel Castro Armario]

The parse error is due to Tempo custom field expect a number instead of a string value. It is not a bug,

[Fidel Castro Armario]

Hi @laceymcdonnell,

Since version 2.2.39, JIRA Workflow Toolbox supports Custom Schedules, and you can do all you are doing now using addTimeSkippingWeekends () and subtractDatesSkippingWeekends () functions, and much much more.

I recommend you to take a look at it. You will be able to do amazing things using it.