Skip to main content Skip to complementary content

GetTablesAndKeys method

Returns:

The list of tables in an app and the fields inside each table.
The list of derived fields.
The list of key fields.

Parameters

Name	Description	Mandatory	Type
qWindowSize	Size of the window that is used to display the results.	Yes	Size
qNullSize		Yes	Size
qCellHeight	Height of a cell in a table in pixels.	Yes	Integer
qSyntheticMode	One of: true for internal table viewer: Shows a more detailed view on how the Qlik engine defines the relations between fields and the quality of the keys. false for source table viewer: Shows the natural relation between fields without reference to synthetic keys and resultant linking synthetic tables. Instead synthetic keys are represented by multiple connectors between tables.	Yes	Boolean
qIncludeSysVars	If set to true, the system variables are included.	Yes	Boolean
qIncludeProfiling	If set to true, profiling information is included.	No	Boolean

Returns

Name	Description	Type
qtr	List of tables.	Array of TableRecord
qk	List of keys.	Array of SourceKeyRecord

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here