All GetTable function options.
rowHeaders |
enum RowHeaders.TYPE typedef uint8_t RowHeadersTYPE;
|
Include headings in first row MAINLABEL (main headings), SHORTLABEL (short label headings), and NONE (without headings)
|
|
rowProperties |
boolean |
First row contains property names.
|
|
onlyVisibles |
boolean |
Use only Visible Schemas and Properties
|
|
usePropertyNames |
boolean |
Use Properties and Table names.
|
|
repeatValues |
boolean |
Repeat common attributes in MV and SV groups
|
|
applyConversion |
boolean |
Execute Conversions: With Dictionaries, conversion defined in the dictionary, with Schemas conversions defined in Linkar Schemas.
|
|
applyFormat |
boolean |
Execute Formats. With Dictionaries, formats defined in the dictionary, with Schemas formats defined in Linkar Schemas.
|
|
calculated |
boolean |
return the resulting values from the calculated dictionaries.
|
|
pagination |
boolean |
false |
indicates if pagination is being used or not
|
regPage |
Numeric |
10 |
in case of pagination indicates the number of records by page. This must be greater than 0
|
numPage |
Numeric |
1 |
in case of pagination indicates the number of records by page. This must be greater than 0
|
rowHeaders
|
enum RowHeaders.TYPE typedef uint8_t RowHeadersTYPE;
|
|
Include headings in first row MAINLABEL (main headings), SHORTLABEL (short label headings), and NONE (without headings) |
rowProperties
|
boolean |
|
First row contains property names. |
onlyVisibles
|
boolean |
|
Use only Visible Schemas and Properties |
usePropertyNames
|
boolean |
|
Use Properties and Table names. |
repeatValues |
boolean |
|
Repeat common atributes in MV and SV groups
|
applyConversion |
boolean |
|
Execute Conversions: With Dictionaries, conversion defined in the dictionary. with Schemas conversions defined in Linkar Schemas.
|
applyFormat |
boolean |
|
Execute Formats. With Dictionaries, formats defined in the dictionary. with Schemas formats defined in Linkar Schemas.
|
calculated |
boolean |
|
return the resulting values from the calculated dictionaries.
|
pagination
|
boolean |
false |
indicates if pagination is being used or not |
regPage
|
Numeric |
10 |
in case of pagination indicates the number of records by page. It must be bigger than 0 |
numPage |
Numeric |
1 |
in case of pagination indicates the number of records by page. It must be bigger than 0
|
There are 4 constructors for each possible Schema Type:
| • | LKSCHEMAS Schema Type. |
| • | SQLMODE Schema Type. |
| • | DICTIONARIES Schema Type. Returns the query using the file dictionaries. |
| • | NONE Schema Type. |
| • | LKSCHEMAS options: Returns the result using the properties defined in Linkar. |
| • | RowHeaders.TYPE |
| • | RowProperties |
| • | OnlyVisibles |
| • | UsePropertyNames |
| • | RepeatValues |
| • | ApplyConversion |
| • | ApplyFormat |
| • | Calculated |
| • | SQLMODE options: Returns the result using the properties defined in Linkar in SQL format. Can make inquiries to the Parent Table attributes or child MV or SV tables. Some examples are: |
Customers LK.CUSTOMERS file.
Items LK.ITEMS file
Orders LK.ORDERS file
Orders.MvItems MV group named MvItems in the LK.ORDERS file
Orders.MvItems.SvDeliveryDates SV group named SvDeliveryDates in the MV MvItems group.
| • | OnlyVisibles |
| • | ApplyConversion |
| • | ApplyFormat |
| • | Calculated |
In this Schema type the RowHeaders optionTYPE value is NONE and the RowProperties, UsePropertyNames and RepeatValues value is true.
| • | DICTIONARIES options: Returns the query using the file dictionaries. |
| • | RowHeaders.TYPE |
| • | RepeatValues |
| • | ApplyConversion |
| • | ApplyFormat |
| • | Calculated |
In this Schema type the RowProperties, OnlyVisibles and UsePropertyNames options type value are false.
| • | NONE options: Returns the query using attribute numbers (a 0, a1, f0 1....) |
| • | RowHeaders.TYPE |
| • | RepeatValues |
In this Schema type RowProperties, OnlyVisibles, UsePropertyNames, ApplyConversion, ApplyFormat and Calculated options value are always false.
