About queries

There are two types of queries:

Request

For this type of query, you specify all the information that you need to process the query.

You enter the:

  • Datastore runtime on which the query will be executed
  • Query input and output definition
  • Period for the data extraction
  • Settings for the query execution:
    • Filter expression
    • Columns selection
    • Aggregation and sort parameters

Function

For this type of query, you define a link to an existing Java exit. You specify the name of the function call and supply the required arguments and their options:

  • Rank
  • Name
  • Type
  • Default value
  • Visible option

Besides the list of parameters, the user can set the:

  • Datastore runtime on which the query will be executed
  • Input definition
  • Period for the data extraction
  • Settings for the query execution

Related Links