The system performs certain actions before and after executing a query.

Entity Based Access Control

Data source can be a database table or REST service. The system checks if user has view access for these data sources.

Query Parameter Validation

The system performs basic parameter validation such as

  • Type: String, Integer,etc.

  • Not null constraint: can it be null or not?

Column Based Access Control

If user has view has access to a database table then the system checks if user has view access to all the columns. User may not have view access to some of them.

Prepare Query

The system prepares SELECT query based on access control output and search parameters given by user.

Execute Query

The system executes the query.

Log Control

If the system was configured to log this query action, it will log information such as execution time of the query and who executed this query.