From wiki.ginstr.com
Jump to: navigation, search
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<br><br>
+
:<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
rowId id of row where the data will be stored
column{n} table column name where the data will be stored
source{n} source from where the data will be used

Example

residents - table name
@variable/documentUpdateId - row id
resident_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]