This topic is locked

Report with Filter

8/19/2008 1:19:46 PM
PHPRunner General questions
W
webdino author

Hello,
I want to create a Report with a Filter.

My databse has this columns ID WERBUNG ITEM Year Week Region

There are many data sets in my table.
Now I want to create a report and the user should choose the shown items with a dropdown or other????

He choose the WEEK Region and than him was shown the items from the Database how to relalize this.
In the next step I will give the user a chance to edit this items but he should choos the week year and Region before he see the items and change it.

Is this realizable. (please not with the search)

J
Jane 8/20/2008

Hi,
if you don't want to use advanced search edit generated files manually, add custom dropdowns and filter records as you want.

Unfortunately we don't have a ready to go solution for this.

W
webdino author 8/20/2008

Hi,

if you don't want to use advanced search edit generated files manually, add custom dropdowns and filter records as you want.

Unfortunately we don't have a ready to go solution for this.



The PHP Runner only shows all items?????

this is not my target.

The user choose some terms and then the list was shown.
Somehow I only can create some files with Master Details.

My report was so not possible and I must programming the report not withe PHPRunner this is not my target, because there is than a mixed up Data and files with my colleagues. The programm on this programm too Bur they programmed it manually in a file and not with PHPRunner.

A
alang 8/20/2008

Unfortunately we don't have a ready to go solution for this.


Jane - Related to this, I would love to see the addition of custom filters. This would provide a drop-down selection box in the list page header which would allow the user to select from a number of custom filters. I would like to see this so that each user could have his own favourites or default filter. Essentially these filters would be a specific configuration of the advanced search screen but would provide a very quick and convenient way to apply advanced search capability. I think many people find the advanced search a little daunting. In addition to the filter specifics it could also alow specification of the "order by" to apply to the list.
As an example, I maintain a list of projects. They have a group, ID number, status, and priority. I would like several filters such as:

  • XYZ Active Project list (where group="XYZ", priority >= 1, ordered by priority)
  • XYZ Initiated (where group="XYZ", status = "Initiated", ordered by ID number)

J
Jane 8/21/2008

Alan,
yes, it's a good trick. However this workaround (dropdown with saved search parameters) is for static pre-defined filters. Advanced search is more suitable for selecting some arbitrary search parameters.