Tutorial: Advanced search with relative periods

Read tutorial See sample

This tutorial shows how to use special conditions for Date fields in a Search.

Creating a new grid

Create a new grid application using the table “sales”.

Into the initial options “Grid Modules”, select the “Search” as the initial Module and uncheck the unnecessary application modules.

Click on Fields Positioning in the menu and select the fields that you want to display on the Grid.

Open the Search menu and click on “Advanced Search >> Select Fields” to choose the Date field.

Now access the “Search Criteria” option.

Choose the search criterias to field. Selecting the field on the left panel then click on the “All” button.

Still in the Search menu, open the “Fields” folder and click on the “Date” field.

Open the “Special Conditions” tab, select the option “Specials/Normals” and check the boxes for the periods you want to use.

Click the Run button on the toolbar.

Tutorials in the same category

Card View HTML

This tutorial demonstrates how to create a Grid application using the “User defined” ori...

Evaluation Field in the Grid

In this tutorial, you will see how to use the evaluation fields in a Grid application. We ...

Evaluation Field in Summary

In this tutorial, you will see how to create a Summary by using the evaluation fields. We can use ...

Grid with fixed toolbar

In this example, we are going to develop a report using a fixed toolbar on the top so we can...