The Refined Search is used to improve your reports by adding restrictive values according to the data universe from your database. The new refined search will offer a slider component for selecting the ranges. The result of the search will be shown using AJAX without the need of reloading the report content.

Let’s take a look on one example from our site and how it was done using Scriptcase.

Examplehttp://www.scriptcase.net/scriptcase-samples/news-scriptcase/refined-search/

 

Tutorial:

In this example we will develop a report using the refined filter option, which allows you to filter the Grid values at runtime.

 

 

Creating a New Grid

1. Create a new grid application using the Customers table.

2. Select the fields CompanyName, ContactName, ContactTitle, BirthDate, Country, Address and CreditLimit, by using the Fields Positioning option located in the application menu.

 

 

3. In the application menu, access the Refined Filter folder and click on the item Select Fields

 

 

4. In the first tab (Select Fields), we will select the fields Country, CreditLimit and BirthDate.

 

 

5. In the second tab (Edit Fields) will use the settings according to the image below.

 

 

6. Click “Run application”

 

 

Do you want to see more Scriptcase examples? Take a look at our samples page at http://www.scriptcase.net/scriptcase-samples/

You might also like…

Do they pay for your system or code?

For all those who develop system and softwares every day at work: Have you ever wondered what makes...

What is Business Intelligence anyways?

Surely you have listened about the expression, “BI” or “Business Intelligence”, the questio...

Scriptcase & Web Services

This time I will explain how to work with web services inside the Scriptcase, directly with PHP and...

You might also like…

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.