Filter the records of the table view

[corestat.consulting]

Hello!

Is it possible to make custom query for the table view?
For example when I click on 'report' it prints out all the records found in the 'report' table in my database, but how can I filter the shown records by e.x. WHERE date > '2008-03-10'?

Thank you for you help,
Benedek RAKOVICS

[shannah]

Hi,

There are a couple of strategies you can take here.

1. Provide a default query for the reports table.
2. Create a special menu item or link to a filtered version of the reports table.

Both of these strategies take advantage of Xataface's url conventions.

e.g. if you go to the URL:
index.php?-table=reports&date=>2008-03-10
It will give you what you want.

You can either add a link to this, or add some logic at the beginning of your index.php file to add this query.

Let me know if you want more details.

-Steve

[corestat.consulting]

Thank you for you reply!

What I'm actually trying to do is this:
http://wififalu.myip.hu/wifi.jpg

I'm trying to make a new table by getting the 'telepules's from the 'onkormanyzat' and 'cko' tables where levelben='Igen'. The blue ones are the columns which don't have any relationship. The first part (where it gets the 'telepules's) of the application is the one which is a bit hard for me to understand on how should I do it.

Thanks,
Benedek

[shannah]

OK... so you want to print a report that spans multiple tables.

There are 2 options:
1. Create a view that meets your report criteria (MySQL 5+).

2. If you don't have MySQL 5, then you can create a custom action to print your results.

-Steve