table_export_query: Create table export query

In ingef/cqapiR: Provides Connection to Conquery

Description

Creates table export query for getting raw data in conquery

Usage

table_export_query(
  connection,
  query_id,
  start_date,
  end_date,
  connector_id,
  date_column
)

Arguments

connection	connection object
query_id	query_id of the population
start_date	start date for date restriction of table data
end_date	end date for date restriction of table data
connector_id	id of connector that contains raw data
date_column	column name of column that is checked for date restriction

Value

table export query

Examples

table_query = table_export_query(connection = connection,
                                 query_id = query_id,
                                 start_date="2017-01-01",
                                 end_date="2017-01-31",
                                 connector_id = "fdb_destatis.alter.alter",
                                 date_column = "fdb_destatis.alter.alter.versichertenzeit")

table_query_id = execute_query(connection, table_query)

ingef/cqapiR documentation built on Dec. 20, 2021, 7:02 p.m.