Defining a Pre Query

The pre-query script lets you specify any custom search clause that will be appended to the default search criteria generated by the platform. You can manipulate the different components of the query that are used during the search. When your application requires implementing custom search, you can write pre query script on the datasource. The platform invokes the pre-query script for performing a search, allowing the developer to control the query being executed to obtain appropriate results.

You must write the pre-query script in the Java programming language.

• To define a pre-query, open the </>Pre Query tab. The query editor is displayed. You can define your pre-query here as per the requirement.

• You can call the predefined pre-query methods directly from the editor. On entering db. in the text editor, the list of methods is displayed. You can click on the required method from this list.