From wiki.ginstr.com
Jump to: navigation, search
(Created page with "=Gn:act_rawQueryToWidgets= Action is used to query data from database from multiple columns and store value to multiple targets. ==Base action signature:== <pre>[gn:act_rawQ...")
 
Line 1: Line 1:
 
=Gn:act_rawQueryToWidgets=
 
=Gn:act_rawQueryToWidgets=
 +
[[Category:Actions]]
  
 
Action is used to query data from database from multiple columns and store value to multiple targets.
 
Action is used to query data from database from multiple columns and store value to multiple targets.

Revision as of 15:53, 22 June 2016

Gn:act_rawQueryToWidgets

Action is used to query data from database from multiple columns and store value to multiple targets.

Base action signature:

[gn:act_rawQueryToWidgets]|[table,query,limit,skip,queryType;columns;targets;keys]

Signature variations examples:

  • [gn:act_rawQueryToWidgets]|[table,query;column,...,column1; tar-get,...,target1;key,...,key1]
i.e. Query with keys
[gn:act_rawQueryToWidgets]|[users,usersBySerial;userName,userSurname; @variable/userName,@+id/gnEditTextUserName;@variable/userSerial]
  • [gn:act_rawQueryToWidgets]|[table,query;column,...,column1; tar-get,...,target1]
i.e. Query without keys
[gn:act_rawQueryToWidgets]|[users,allUsers;userName,userSurname;@variable/userName,@+id/gnEditTextUserSurname]
  • [gn:act_rawQueryToWidgets]|[table,query,limit,skip;columns;keys]
i.e. Query that returns specific set of data based on limit and skip params
[gn:act_rawQueryToWidgets]|[users,usersByNfc,10,@+id/skipNumber;userName,userSurname;@+id/userNfc]
  • [gn:act_rawQueryToWidgets]|[table,query,,,queryType;columns;targets;keys]
i.e. Query with keys and queryType and no limit,skip parameters
  • [gn:act_rawQueryToWidgets]|[table,query;columns;targets;startKeys;endKeys]

[gn:act_rawQueryToWidgets]|[table,query,,,queryType;columns;targets;startKeys;endKeys]

i.e. Query by range
[gn:act_rawQueryToWidgets]|[table,query;username,userSurname;@+id/targetGnEdi-tUserName,@+id/targetGnEditUserSurName;@variable/keyStartOne;@variable/keyEndOne]

Value field content:

table 
table from which to query data
query 
dbRequest which is used to execute the query
target 
targets to store values from database can be
limit 
defines the number of returned rows
skip 
defines the number of skipped rows
column 
column from table to load
key,...,key 
keys to use as values for query can be
queryType 
defines type of query to be executed. Query can be

Can be used on widgets:

  • any

Additional required attributes on bound widget:

  • none

Event trigger for action:

no event must be added to action set or conditional widget

Can be used as:

  • as no event action