Get month as a number (0-11)
Returns the year of a date as an integer relative to 1900.
Get month as a number (0-11)
Returns the year of a date as an integer relative to 1900.
toString()
Please remove the entire line. This function is not implemented.
f])
missing ' f'])
e
missing "(" (entity..
’]
missing ")"
'])
f])
missing ' <entity['udf'])
e
missing "("
(entity['bucket_rank_udf']< entity['udf'])
’]
missing ")" '])
Percent
Returns the integer remainder of dividing the two operands.
Ex: 12 % 5 returns 2
bucket_rank
actual_story_points
bucket_rank
bucket_rank_udf
bucket_rank
bucket_rank_udf
bucket_rank
bucket_rank_udf
Mathceil
Math.ceil "." is missing
The result of the expression must match the value type of the field
Here we can state that the client doesn't verify the match, it's the admin who must ensure this.
))
Please add another line below this one:
isEqual(date1, date 2) DateUtils.isEqual(entity['done_date'], entity['last_modified']) Verifies if the values of 2 date fields are equal. '==' and '!=' are not supported for date fields.
entiy[‘date_udf1’].Value!=entiy[‘date_udf2’].Value; entiy[‘date_udf’].Value==(new Date())
Please replace the example with: Date.current() <= DateUtils.addWeeksToDate(entity['creation_time'], 2)
==, !=,
Please remove == and !=
3)
Please add before this line: DateUtils.addSecondsToDate(date, seconds) DateUtils.addSecondsToDate(entity['creation_time'],55) Adds the seconds to the date field value. Example and Description for this line: DateUtils.addMinutesToDate(entity['creation_time'], 30) Adds the minutes to the date field value.
add
For all add functions we need to add ToDate to the function name: addMinutesToDate addHoursToDate . . .
)
Example and Description: DateUtils.subtractMinutes(entity['last_modified'],55) Subtracts a specified number of minutes from a date field value.
Please add a line for DateUtils.subtractYears(date, years)
subtractWorkDays(date,days)
Replace the line with: subtractMonths(date, months) DateUtils.subtractMonths(entity['last_modified'],2) Subtracts a specified number of months from a date field value.
)
Example and Description: DateUtils.subtractWeeks(entity['last_modified'],2) Subtracts a specified number of weeks from a date field value.
DateUtils.addMinutesToDate(new Date(),2)
Example and Description: DateUtils.subtractDays(entity['last_modified'],3) Subtracts a specified number of days from a date field value.
)
Example and Description: DateUtils.subtractHours(entity['last_modified'],2) Subtracts a specified number of hours from a date field value.
Substracts
Please add before this line: DateUtils.subtractSeconds(date, seconds) DateUtils.subtractSeconds(entity['last_modified'],55) Subtracts a specified number of seconds from a date field value.
ad
Please add after this line: DateUtils.addYearsToDate(date, seconds) DateUtils.addYearsToDate(entity['creation_time'],2) Adds years to the date field value.
)
Example and Description: DateUtils.addMonthsToDate(entity['creation_time'], 2) Add months to the date field value.
)
Example and Description: DateUtils.addDaysToDate(entity['creation_time'], 2) <br /> Adds days to the date field value.
)
Example and Description: DateUtils.addHoursToDate(entity['creation_time'], 2) Adds weeks to the date field value.
)
Example and Description: DateUtils.addHoursToDate(entity['creation_time'], 2) Adds hours to the date field value.
2)
Description: Difference between 2 date fields in years.
2)
Description: Difference between 2 date fields in months.
2)
Description: Difference between 2 date fields in weeks.
2)
Description: Difference between 2 date fields in days.
2)
Description: Difference between 2 date fields in hours.
2)
Description for this line: Difference between 2 date fields in minutes.
Entiy[‘date_udf’] == now()
remove the line. We documented it above
Date1 – Date2
Please remove this line
toLocaleDateString([locales[, options]])
Please remove. Not implemented
getTimezoneOffset()
Please remove. Not implemented
)
In the Description column: Parses a string representation of a date, and returns the date's timestamp.
Static instantiation of a new Date
Replace with: Creates a new object representing the current date and time.
new epoch / timestamp (long)
replace with: Returns the number of milliseconds since January 1, 1970, UTC (the Unix epoch).
(entity[‘udf’] > entity[‘udf’].originalValue) ? entity[‘udf’] : entity[‘udf’].originalValue)
originalValue is not implemented for Verve release. Let' replace with this one: (entity['story_points'] > entity['actual_story_points']) ? entity['story_points'] : entity['actual_story_points']
Same as slice(), but the negative indexes are treated as 0.
Extracts a substring starting from the first parameter index up to the second parameter.
Gets the new value of the field
It is used for integer and string types, in equality and inequality operators
originalValue
not yet implemented. Only in Westlife
count(enity.children
CollectionUtils.count(entity.product_areas)
we dont support yet children. But we support other fields that are Collections: application modules, multi value lists, teams, etc
count()
count(collection)
entity's child items.
items in the collection
==
" == " - let's add space before and after
V
small v
]
.value
Both equality and inequality operators are not supported without ".value"
]
.value
V
small v
V
v - small
avg
MathUtils.avg(entity....)
Let's put in the example column the exact syntax that needs to be used.
All the above examples use Math class: Math.min(a,b,);.. Math.pow(x,y)
sum(collection) sum(entity.children.int_udf) Returns the sum of all entity's children's int value. avg(epression) avg(enity.children.story_points) Returns the average value calculated from all the entity’s children. count() count(enity.children)
to be removed - all 3. Not implemented
round(expression,nr_of_digits)
not implemented - to be removed
r
R - capital
entity[‘x’]
entity.udf1/entity.udf2
max(collection)
Not implemented yet. We should add this in Westlife release
min(collection)
Not implemented yet. We should add this for Westlife release
entity[‘story_points’],entity[‘actual_story_points’],entity[‘udf’],..
Currently, we support also these annotations for calling the properties of the entities: entity.story_points; entity.actual_story_points. We should document both
on
I would emphasize that the dynamic values comes from the values of other fields. maybe "...based on other field values using JavaScript expressions"