Xataface Forums

Steve,
Can I create my own view by creating a subfolder (called "TodaysVisits") in the tables directory and then create a fields.ini file in that subfolder?

what is the exact syntax for the sql query in the fields.ini

I want to do something like
[TodaysVisits]
__sql__="select *, where (field called "visit timestamp") > today -1, sort on (field called "visit timestamp"), from clients"

This way I can see all records in the clients table that have timestamps of today in order received.

I want to be able to to put an entry in my dashboard.html that looks something like:

<li>
<img src="{$ENV.DATAFACE_URL}/images/edit.gif"/>
<a href="{$ENV.DATAFACE_SITE_HREF}?-table=TodaysVisits&-action=list">List of waiting clients:</a>
</li>

I decided to create a view in MySql and then add that view to my [_tables] in the conf.ini file. That seemed to work and it was easy.

shardison wrote:I decided to create a view in MySql and then add that view to my [_tables] in the conf.ini file. That seemed to work and it was easy.

i agree this ...