Views

Archived from the Xataface Users forum.

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:

  • List of waiting clients:

    • 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.

    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 …