Trace:
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
visionx:actions [2022/09/15 19:48] robot |
visionx:actions [2023/04/04 11:03] (current) robot |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ~~Title: VisionX Actions~~ | ~~Title: VisionX Actions~~ | ||
| - | Version: 1.0 / 2022-09-15 | + | Version: 1.0 / 2023-04-04 |
| ====== Introduction ====== | ====== Introduction ====== | ||
| Line 3424: | Line 3424: | ||
| Group functions calculate results based on all values in a table column. A list is created using each row in the table column; the group function is then applied to this list. E.g. ''%%avg([Items.Price])%%'' which returns the average of the prices in the table "Items". | Group functions calculate results based on all values in a table column. A list is created using each row in the table column; the group function is then applied to this list. E.g. ''%%avg([Items.Price])%%'' which returns the average of the prices in the table "Items". | ||
| - | In addition, all functions are available in the variant to return ''%%null%%'' if all values in the column were ''%%null%%''. These variants have the same name but are postfixed with "Null", E.g. ''%%avgNull([Items.Price])%%''. For additional information see [[http://en.wikipedia.org/wiki/Null_(SQL)|the Wikipedia entry on SQL Null]]. | + | In addition, all functions are available in the variant to return ''%%null%%'' if all values in the column were ''%%null%%''. These variants have the same name but are postfixed with "NoValue", E.g. ''%%avgNoValue([Items.Price])%%''. For additional information see [[http://en.wikipedia.org/wiki/Null_(SQL)|the Wikipedia entry on SQL Null]]. |
| The group functions can be used with the following actions: | The group functions can be used with the following actions: | ||
| Line 3438: | Line 3438: | ||
| * [[#set_parameter_with_calculated_value|Set Parameter with calculated value]] | * [[#set_parameter_with_calculated_value|Set Parameter with calculated value]] | ||
| - | ==== avg / avgNull ==== | + | ==== avg / avgNoValue ==== |
| Returns the average of all values. | Returns the average of all values. | ||
| Line 3447: | Line 3447: | ||
| <code java> | <code java> | ||
| avg([Items.Price]) | avg([Items.Price]) | ||
| - | avgNull([Items.Price]) | + | avgNoValue([Items.Price]) |
| </code> | </code> | ||
| - | ==== min / minNull ==== | + | ==== min / minNoValue ==== |
| Returns the smallest value. | Returns the smallest value. | ||
| Line 3458: | Line 3458: | ||
| <code java> | <code java> | ||
| min([Items.Price]) | min([Items.Price]) | ||
| - | minNull([Items.Price]) | + | minNoValue([Items.Price]) |
| </code> | </code> | ||
| - | ==== max / maxNull ==== | + | ==== max / maxNoValue ==== |
| Returns the largest value. | Returns the largest value. | ||
| Line 3469: | Line 3469: | ||
| <code java> | <code java> | ||
| max([Items.Price]) | max([Items.Price]) | ||
| - | maxNull([Items.Price]) | + | maxNoValue([Items.Price]) |
| </code> | </code> | ||
| - | ==== count / countNull ==== | + | ==== count / countNoValue ==== |
| Returns the number of entries. | Returns the number of entries. | ||
| Line 3480: | Line 3480: | ||
| <code java> | <code java> | ||
| count([Items.Price]) | count([Items.Price]) | ||
| - | countNull([Items.Price]) | + | countNoValue([Items.Price]) |
| </code> | </code> | ||
| - | ==== sum / sumNull ==== | + | ==== sum / sumNoValue ==== |
| Returns the sum of all values. | Returns the sum of all values. | ||
| Line 3491: | Line 3491: | ||
| <code java> | <code java> | ||
| sum([Items.Price]) | sum([Items.Price]) | ||
| - | sumNull([Items.Price]) | + | sumNoValue([Items.Price]) |
| </code> | </code> | ||
| - | ==== sumToCurrent / sumToCurrentNull ==== | + | ==== sumToSelected / sumToSelectedNoValue ==== |
| Returns the sum of values from the first row to the selected row. | Returns the sum of values from the first row to the selected row. | ||
| Line 3501: | Line 3501: | ||
| <code java> | <code java> | ||
| - | sumToCurrent([Items.Price]) | + | sumToSelected([Items.Price]) |
| - | sumToCurrentNull([Items.Price]) | + | sumToSelectedNoValue([Items.Price]) |
| </code> | </code> | ||
| - | ==== first / firstNull ==== | + | ==== first / firstNoValue ==== |
| Returns the first value. | Returns the first value. | ||
| Line 3513: | Line 3513: | ||
| <code java> | <code java> | ||
| first([Items.Price]) | first([Items.Price]) | ||
| - | firstNull([Items.Price]) | + | firstNoValue([Items.Price]) |
| </code> | </code> | ||
| - | ==== last / lastNull ==== | + | ==== last / lastNoValue ==== |
| Returns the last value. | Returns the last value. | ||
| Line 3524: | Line 3524: | ||
| <code java> | <code java> | ||
| first([Items.Price]) | first([Items.Price]) | ||
| - | firstNull([Items.Price]) | + | firstNoValue([Items.Price]) |
| </code> | </code> | ||
| ===== Date calculation ===== | ===== Date calculation ===== | ||
| Line 3746: | Line 3746: | ||
| ^Before ^After ^ | ^Before ^After ^ | ||
| |"July 22, 2022, 9:40:10.991 AM" |"July 22, 2022, 9:40:10.000 AM" | | |"July 22, 2022, 9:40:10.991 AM" |"July 22, 2022, 9:40:10.000 AM" | | ||
| + | |||
| + | ==== now ==== | ||
| + | |||
| + | Gets the current timestamp. | ||
| + | |||
| + | ^Parameter ^Description ^Example ^ | ||
| + | |||
| + | <code java> | ||
| + | now() | ||
| + | </code> | ||
| + | ^Result ^ | ||
| + | |"July 22, 2022, 9:40:10.991 AM" | | ||
| ===== Date group functions ===== | ===== Date group functions ===== | ||
| Line 3751: | Line 3763: | ||
| Group functions calculate results based on all values in a table column. A list is created using each row in the table column; the group function is then applied to this list. E.g. ''%%avg([Items.Price])%%'' which returns the average of the prices in the table "Items". | Group functions calculate results based on all values in a table column. A list is created using each row in the table column; the group function is then applied to this list. E.g. ''%%avg([Items.Price])%%'' which returns the average of the prices in the table "Items". | ||
| - | In addition, all functions are available in the variant to return ''%%null%%'' if all values in the column were ''%%null%%''. These variants have the same name but are postfixed with "Null", E.g. ''%%minNull([Customers.Birthdate])%%''. For additional information see [[http://en.wikipedia.org/wiki/Null_(SQL)|the Wikipedia entry on SQL Null]]. | + | In addition, all functions are available in the variant to return ''%%null%%'' if all values in the column were ''%%null%%''. These variants have the same name but are postfixed with "NoValue", E.g. ''%%minNoValue([Customers.Birthdate])%%''. For additional information see [[http://en.wikipedia.org/wiki/Null_(SQL)|the Wikipedia entry on SQL Null]]. |
| The date group functions can be used with the following actions: | The date group functions can be used with the following actions: | ||
| Line 3763: | Line 3775: | ||
| * [[#set_parameter_with_calculated_value|Set Parameter with calculated value]] | * [[#set_parameter_with_calculated_value|Set Parameter with calculated value]] | ||
| - | ==== first / firstNull ==== | + | ==== first / firstNoValue ==== |
| Returns the date value of the first row in the table with an existing value. If the value of the last row is empty the value of the row before with an existing value is taken. | Returns the date value of the first row in the table with an existing value. If the value of the last row is empty the value of the row before with an existing value is taken. | ||
| Line 3772: | Line 3784: | ||
| <code java> | <code java> | ||
| first([Contacts.current date]) | first([Contacts.current date]) | ||
| - | firstNull([Contacts.current date]) | + | firstNoValue([Contacts.current date]) |
| </code> | </code> | ||
| - | ==== last / lastNull ==== | + | ==== last / lastNoValue ==== |
| Returns the date value of the last row in the table with an existing value. If the value of the last row is empty the value of the row before with an existing value is taken. | Returns the date value of the last row in the table with an existing value. If the value of the last row is empty the value of the row before with an existing value is taken. | ||
| Line 3783: | Line 3795: | ||
| <code java> | <code java> | ||
| last([Contacts.current date]) | last([Contacts.current date]) | ||
| - | lastNull([Contacts.current date]) | + | lastNoValue([Contacts.current date]) |
| </code> | </code> | ||
| - | ==== min / minNull ==== | + | ==== min / minNoValue ==== |
| Returns the smallest date value in the table. | Returns the smallest date value in the table. | ||
| Line 3794: | Line 3806: | ||
| <code java> | <code java> | ||
| min([Contacts.Birthday]) | min([Contacts.Birthday]) | ||
| - | minNull([Contacts.Birthday]) | + | minNoValue([Contacts.Birthday]) |
| </code> | </code> | ||
| - | ==== max / maxNull ==== | + | ==== max / maxNoValue ==== |
| Returns the greatest date value in the table. | Returns the greatest date value in the table. | ||
| Line 3805: | Line 3817: | ||
| <code java> | <code java> | ||
| max([Contacts.Birthday]) | max([Contacts.Birthday]) | ||
| - | maxNull([Contacts.Birthday]) | + | maxNoValue([Contacts.Birthday]) |
| </code> | </code> | ||
| - | ==== avg / avgNull ==== | + | ==== avg / avgNoValue ==== |
| Returns the average date value in the table. | Returns the average date value in the table. | ||
| Line 3816: | Line 3828: | ||
| <code java> | <code java> | ||
| avg([Contacts.Birthday]) | avg([Contacts.Birthday]) | ||
| - | avgNull([Contacts.Birthday]) | + | avgNoValue([Contacts.Birthday]) |
| </code> | </code> | ||
| - | ==== sumToCurrent / sumToCurrentNull ==== | + | ==== sumToSelected / sumToSelectedNoValue ==== |
| Adds the date values from the beginning up to and including the current row . | Adds the date values from the beginning up to and including the current row . | ||
| Line 3826: | Line 3838: | ||
| <code java> | <code java> | ||
| - | sumToCurrent([Contacts.Birthday]) | + | sumToSelected([Contacts.Birthday]) |
| - | sumToCurrentNull([Contacts.Birthday]) | + | sumToSelectedNoValue([Contacts.Birthday]) |
| </code> | </code> | ||
| - | ==== sumFromCurrent / sumFromCurrentNull ==== | + | ==== sumFromSelected / sumFromCurrentNoValue ==== |
| Adds the date values from the current row up to and including the last row . | Adds the date values from the current row up to and including the last row . | ||
| Line 3837: | Line 3849: | ||
| <code java> | <code java> | ||
| - | sumFromCurrent([Contacts.Birthday]) | + | sumFromSelected([Contacts.Birthday]) |
| - | sumFromCurrentNull([Contacts.Birthday]) | + | sumFromCurrentNoValue([Contacts.Birthday]) |
| </code> | </code> | ||
| - | ==== sum / sumNull ==== | + | ==== sum / sumNoValue ==== |
| Adds the date values from the table. | Adds the date values from the table. | ||
| Line 3849: | Line 3861: | ||
| <code java> | <code java> | ||
| sum([Contacts.Birthday]) | sum([Contacts.Birthday]) | ||
| - | sumNull([Contacts.Birthday]) | + | sumNoValue([Contacts.Birthday]) |
| </code> | </code> | ||
| ==== count ==== | ==== count ==== | ||
| Line 3875: | Line 3887: | ||
| row([Contacts.Birthday]) | row([Contacts.Birthday]) | ||
| </code> | </code> | ||
| - | ==== null ==== | + | ==== noValue ==== |
| Returns an empty value. | Returns an empty value. | ||
| Line 3883: | Line 3895: | ||
| <code java> | <code java> | ||
| - | null([Contacts.Birthday]) | + | noValue([Contacts.Birthday]) |
| </code> | </code> | ||
| ===== Text operations ===== | ===== Text operations ===== | ||
| Line 3948: | Line 3960: | ||
| ^Before ^After ^ | ^Before ^After ^ | ||
| |" ̺ ̺ ̺ ̺ ̺12345 ̺ ̺ " |"12345 ̺ ̺ " | | |" ̺ ̺ ̺ ̺ ̺12345 ̺ ̺ " |"12345 ̺ ̺ " | | ||
| - | |" ̺ ̺ 15349 ̺ ̺ " |"15349 ̺ ̺ " | | + | |" ̺ ̺15349 ̺ ̺ " |"15349 ̺ ̺ " | |
| ==== rtrim ==== | ==== rtrim ==== | ||
| Line 3963: | Line 3975: | ||
| ^Before ^After ^ | ^Before ^After ^ | ||
| |" ̺ ̺12345 ̺ ̺ ̺ ̺ ̺ " |" ̺ ̺12345" | | |" ̺ ̺12345 ̺ ̺ ̺ ̺ ̺ " |" ̺ ̺12345" | | ||
| - | |" ̺ ̺ 15349 ̺ ̺ " |" ̺ ̺ 15349" | | + | |" ̺ ̺15349 ̺ ̺ " |" ̺ ̺15349" | |
| ==== trim ==== | ==== trim ==== | ||
| Line 3978: | Line 3990: | ||
| ^Before ^After ^ | ^Before ^After ^ | ||
| |" ̺ ̺12345 ̺ ̺ ̺ ̺ ̺ " |"12345" | | |" ̺ ̺12345 ̺ ̺ ̺ ̺ ̺ " |"12345" | | ||
| - | |" ̺ ̺ 15349 ̺ ̺ " |"15349" | | + | |" ̺ ̺15349 ̺ ̺ " |"15349" | |
| + | |||
| + | ==== user ==== | ||
| + | |||
| + | Gets the current logged on user. | ||
| + | |||
| + | ^Parameter ^Description ^Example ^ | ||
| + | |||
| + | <code java> | ||
| + | user() | ||
| + | </code> | ||
| + | ^Result ^ | ||
| + | |"admin" | | ||