troych
Posts: 9
|
| Posted: 06/26/2011, 5:21 PM |
|
hi
i want to be able to have a link in the grid header and when i click it , it will display all the current date records in the grid.
you will see in the demo a field called " Scheduled" with a date in it, so when i click on the link it will display the current dates records,
at the moment it displays the ID desc which i want to keep i just want the option of the user to be able to display the current date records as well
the link below is the grid
http://www.timaru.gen.nz/trs/data/log.php
user=demo pass= demo
thank you
|
 |
 |
jjrjr2
Posts: 131
|
| Posted: 06/27/2011, 3:06 AM |
|
Hi
In CCS this is very easy..
First add a link component to your grid with a URL parameter using an expression as the source. Have that expression be a form of the PHP date() function that returns the date in the date format in your database
Next, using query builder for your grid, add a query that selects records who's scheduled date matches the date sent in the URL parameter sent above...
U just gotta be sure the date format in the URL parameter matches the date format you are using in your table for schedued date,
Hope that helps.
 John
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
Real Web Development At: http://RealWebDevelopment.us |
|
|
|
|
