Click or drag to resize
IUserAccessiableGetTableFromStore Method (String, String, String, String)
Will get the name of the subject store, and SQL commands to pull through data out of the Table. in JS should be inserted into a ‘var’ type.

Namespace: SurveyToGo.UserLogic.Interfaces
Assembly: UserLogicInt.Pocket (in UserLogicInt.Pocket.dll) Version: 1.0.4.0
Syntax
C#
Copy
ITable GetTableFromStore(
	string inStoreName,
	string inColumns,
	string inWhere,
	string inOrder
)

Parameters

inStoreName
Type: SystemString
Name of the subject store
inColumns
Type: SystemString
Column name in SQL
inWhere
Type: SystemString
Where command in SQL
inOrder
Type: SystemString
Order command in SQL

Return Value

Type: ITable
Examples
if I would like to get specific data from my table, I can use this function as follows: GetTableFromStore("my_store123","country","@@country='UK'","") (*the ‘@@’ is needed from internal system requirements) This will return rows from ‘country’ column then you can use this row to pull out from its columns: if we put the row inside a var called ‘myrow’, for example: var myTable = GetTableFromStore("my_store123","Country","@@[Country] = 'UK'",""); var myRow = myTable[0]; would place in myRow the first row in myTable and to access a specific value in a specific column, for example a column called Country_Airports, we can do var countryAirport = myRow["Country_Airports"]; for UK, the first can return Heathrow (or Gatwik or whatever airport name appears in the first row).
See Also