Views

A place for users and developers of the Xataface to discuss and receive support.

Views

Postby shardison » Sat Aug 25, 2012 7:26 am

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>
shardison
 
Posts: 24
Joined: Wed Aug 08, 2012 12:09 pm

Re: Views

Postby shardison » Mon Aug 27, 2012 6:12 pm

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
 
Posts: 24
Joined: Wed Aug 08, 2012 12:09 pm

Re: Views

Postby partha » Sat Sep 01, 2012 5:34 am

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 ...
partha
 
Posts: 1
Joined: Fri Aug 31, 2012 10:37 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 20 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved