(→code) |
m (formatting) |
||
| Line 17: | Line 17: | ||
===Query BLE fingerprint=== | ===Query BLE fingerprint=== | ||
| − | ;<code>[gn:act_queryBLEFingerprint]|[table,query;column;target]</code> | + | :;<code>[gn:act_queryBLEFingerprint]|[table,query;column;target]</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 which will be queried | | table name which will be queried | ||
|- | |- | ||
| − | | query | + | | <code>query</code> |
| query name which will be used for query | | query name which will be used for query | ||
|- | |- | ||
| − | | column | + | | <code>column</code> |
| column name which will be used for value retrieval | | column name which will be used for value retrieval | ||
|- | |- | ||
| − | | [[target]] | + | | <code>[[target]]</code> |
| [[target]] where the value will be stored | | [[target]] where the value will be stored | ||
* Valid [[target|targets]]: | * Valid [[target|targets]]: | ||
| Line 41: | Line 41: | ||
====Example==== | ====Example==== | ||
| + | :<code>securityBagLocations</code> - table name<br> | ||
| + | :<code>securityBagLocationsQuery</code> - query name<br> | ||
| + | :<code>securityBagLocation_locationName</code> - column name<br> | ||
| + | :<code>@+id/LocationName</code> - target<br> | ||
| + | :; ⤷ <code>[gn:act_queryBLEFingerprint]|[securityBagLocations, securityBagLocationsQuery;securityBagLocation_locationName;@+id/LocationName]</code> | ||
| + | |||
=====queries.xml===== | =====queries.xml===== | ||
<syntaxhighlight code="xml"> | <syntaxhighlight code="xml"> | ||
| Line 55: | Line 61: | ||
securityBagLocation_createdBy" /> | securityBagLocation_createdBy" /> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<hr> | <hr> | ||
Latest revision as of 19:44, 12 July 2017
gn:act_queryBLEFingerprint
- Description
- Action used to return all data for specific user from table which contains BLE fingerprint values.
- After the data is retrieved, this action will then compare current BLE fingerprint with all records and return value from row with the closest BLE fingerprint and sets the defined field value into target widget.
- This query returns only one row with closest BLE fingerprint.
- Action returns
- boolean
- Limitations
- Can only be used in
gn:act_setOnBLEevent.
Action signatures
Query BLE fingerprint
[gn:act_queryBLEFingerprint]|[table,query;column;target]
Parameter Description tabletable name which will be queried queryquery name which will be used for query columncolumn name which will be used for value retrieval targettarget where the value will be stored
Example
securityBagLocations- table namesecurityBagLocationsQuery- query namesecurityBagLocation_locationName- column name@+id/LocationName- target
- ⤷
[gn:act_queryBLEFingerprint]|[securityBagLocations, securityBagLocationsQuery;securityBagLocation_locationName;@+id/LocationName]
- ⤷
queries.xml
<query
id="securityBagLocationsQuery"
columns="securityBagLocation_locationName,
securityBagLocation_locationNFC,
securityBagLocation_geofence,
securityBagLocation_geofenceRadius,
securityBagLocation_bluetoothMAC,
securityBagLocation_WiFiMACIP,
securityBagLocation_cellInfo,
securityBagLocation_createdOn,
securityBagLocation_createdBy" />
