search via a "date range"

larryk

Well-known member
hello, is there a simple way to add a search so you can add criteria for a range of dates?

example:
the order table has ORDER DATE.

but you need 2 dates to search a date range :)
is there an easy way (click buttons) to do this, OR would I need to custom code it.

thanks!

You are using DaDaBIK version 8.0-Lerici enterprise,
PHP Version: 7.0.26
mysql version: 5.5.56-MariaDB
Web server: nginx/1.11.10
 

eugenio

Administrator
Staff member
Hello,
there isn't any built-in feature to do that (it might appear with the next major release); however, an easy way to implement it is the following:

- create a VIEW based on the table you want to search, adding as many additional search fields as you want, e.g.
create view orders_search as select date_order as order_start, date_order as order_end, customer_order, ........ from orders

- then you install the VIEW and you use it only for an "advanced search" search mode in DaDaBIK, so you will have an additional menu item let's say "orders advanced search" that allows you to execute particular searches you cannot do with the normal orders search form

Best,
 
Top