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