This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
novo_motion_schema_editor [2021/02/05 21:19] dlm |
novo_motion_schema_editor [2021/06/08 14:16] (current) mah update @variables |
||
---|---|---|---|
Line 63: | Line 63: | ||
|@LITERAL | Used to pass static data through the schema - @LITERAL:1 | | |@LITERAL | Used to pass static data through the schema - @LITERAL:1 | | ||
|@FIELD | Field based on info - @FIELD: | |@FIELD | Field based on info - @FIELD: | ||
+ | |@FIELDS | Field for multi-value array. | ||
|@TM | Allows selection of a specific table master - @TM: | |@TM | Allows selection of a specific table master - @TM: | ||
|@CHANGE | Used to change a specific string from one literal to another - @CHANGE: | |@CHANGE | Used to change a specific string from one literal to another - @CHANGE: | ||
Line 72: | Line 73: | ||
|@TRIM | Removes errant spaces from a string | |@TRIM | Removes errant spaces from a string | ||
|@NULL | Returns a null character - @NULL | | |@NULL | Returns a null character - @NULL | | ||
+ | |@BLOAT | TBD | | ||
+ | |@USER | Sends the U2 user ID who caused the record change event, or load event | | ||
+ | |@SWAP | Used to change string from one string to another - @SWAP: | ||
+ | |@CAT | Use U2 CATS to combine two arrays of data together - @CAT: | ||
+ | |@TIMESTAMP | transmit a record timestamp for when change / load event happened in U2. This is both date and time in SQL. | | ||
+ | |||
+ | |||
+ | * In SWAP CONVERT etc above, @AM @VM @SVM can be specified as IN or OUT strings. | ||
* Ordinal considerations: | * Ordinal considerations: |