Skip to main content Skip to complementary content
Qlik Resources

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 – let us know how we can improve!

Leave your feedback here