SearchFilter

This class can be used to build search filters that describes how to search for objects in the database.

How to build a search filter

A search filter can be built up by search rules, sort rules, group-by rules, a skip count and a max count.


			
			//PHP 

			$filter = new SearchFilter(); 

			$filter->addSearchRule("name LIKE 'A%'"); 

			$filter->addSearchRule("age < 30", false); 

			$filter->addSortRule("age DESC"); 

			$filter->addGroupByRule("name"); 

			$filter->setPaging(0, 30); //OR:

			$filter->setSkipCount(0);

			$filter->setMaxCount(30);
 

			
			//PHP result:
			 WHERE name LIKE 'A%' AND age < 30 GROUP BY name ORDER BY age DESC LIMIT 0,30
 

			
			//JavaScript 

			var filter = new SearchFilter(); 

			filter.addSearchRule("name LIKE 'A%'"); 

			filter.addSearchRule("age < 30", true); 

			filter.addSortRule("age DESC"); 

			filter.addGroupByRule("name"); 

			filter.setPaging(0, 30); //OR:

			filter.setSkipCount(0);

			filter.setMaxCount(30);
 

			
			//JavaScript result:

Build your own filter

Rate this class :

Discuss this class (No comments):

Write a comment

Load more comments

v. 0.99.2