m (formatting) |
|||
Line 10: | Line 10: | ||
===Update database row=== | ===Update database row=== | ||
− | ;<code>[gn:act_rawUpdateValues]|[table,rowId;column{n};source{n}]</code> | + | :;<code>[gn:act_rawUpdateValues]|[table,rowId;column{n};source{n}]</code> |
− | {| class="wikitable sortable" style="font-size: 85%; text-align: left;" | + | :{| class="wikitable sortable" style="font-size: 85%; text-align: left;" |
|- | |- | ||
! scope="col" | Parameter | ! scope="col" | Parameter | ||
! scope="col" | Description | ! scope="col" | Description | ||
|- | |- | ||
− | | table | + | | <code>table</code> |
| table name where the data will be stored | | table name where the data will be stored | ||
* Valid [[source|sources]]: | * Valid [[source|sources]]: | ||
** hardcoded value | ** hardcoded value | ||
|- | |- | ||
− | | rowId | + | | <code>rowId</code> |
| id of row where the data will be stored | | id of row where the data will be stored | ||
* Valid [[source|sources]]: | * Valid [[source|sources]]: | ||
** any [[source]] | ** any [[source]] | ||
|- | |- | ||
− | | column{n} | + | | <code>column{n}</code> |
| table column name where the data will be stored | | table column name where the data will be stored | ||
* Valid [[source|sources]]: | * Valid [[source|sources]]: | ||
** hardcoded value | ** hardcoded value | ||
|- | |- | ||
− | | [[source]]{n} | + | | <code>[[source]]{n}</code> |
| [[source]] from where the data will be used | | [[source]] from where the data will be used | ||
* Valid [[source|sources]]: | * Valid [[source|sources]]: | ||
Line 40: | Line 40: | ||
====Example==== | ====Example==== | ||
− | <code>residents</code> - table name<br> | + | :<code>residents</code> - table name<br> |
− | <code>@variable/documentUpdateId</code> - row id<br> | + | :<code>@variable/documentUpdateId</code> - row id<br> |
− | <code>resident_employee_firstName,resident_employee_lastName,resident_check_inTime</code> - column names<br> | + | :<code>resident_employee_firstName,resident_employee_lastName,resident_check_inTime</code> - column names<br> |
− | <code>@+id/employee_firstName,@+id/employee_lastName,@variable/checkinTime</code> - source | + | :<code>@+id/employee_firstName,@+id/employee_lastName,@variable/checkinTime</code> - source<br> |
− | <code>[gn:act_rawUpdateValues]|[residents,@variable/documentUpdateId;resident_employee_firstName,resident_employee_lastName,resident_check_inTime;@+id/employee_firstName,@+id/employee_lastName,@variable/checkinTime]</code> | + | :; ⤷ <code>[gn:act_rawUpdateValues]|[residents,@variable/documentUpdateId;resident_employee_firstName, resident_employee_lastName, resident_check_inTime;@+id/employee_firstName, @+id/employee_lastName,@variable/checkinTime]</code> |
<hr> | <hr> |
Revision as of 15:46, 12 July 2017
gn:act_rawUpdateValues
- Description
- Action is used to update data from sources to database record.
- Action returns
- boolean
Action signatures
Update database row
[gn:act_rawUpdateValues]|[table,rowId;column{n};source{n}]
Parameter Description table
table name where the data will be stored - Valid sources:
- hardcoded value
rowId
id of row where the data will be stored column{n}
table column name where the data will be stored - Valid sources:
- hardcoded value
source{n}
source from where the data will be used - Valid sources:
Example
residents
- table name@variable/documentUpdateId
- row idresident_employee_firstName,resident_employee_lastName,resident_check_inTime
- column names@+id/employee_firstName,@+id/employee_lastName,@variable/checkinTime
- source
- ⤷
[gn:act_rawUpdateValues]|[residents,@variable/documentUpdateId;resident_employee_firstName, resident_employee_lastName, resident_check_inTime;@+id/employee_firstName, @+id/employee_lastName,@variable/checkinTime]
- ⤷