Xataface Forums

Hi,

I use widget:type lookup and I want to know if it's possible to customize table select

Example : user table with contract end field > now()

One solution would be to use the widget:filters:* directive and create a grafted field on the users table that is simply a boolean (0 or 1) value.
E.g.
In the users fields.ini file

Code: Select all

__sql__ = "select u.*, if(contract_end>now(),1,0) as contract_active from users u"


Then in your lookup widget field def

Code: Select all

[myfield]
    widget:type=lookup
    widget:table=users
    widget:filters:contract_active=1


Alternatively you could just create a view on the users table that includes only the users that you want in the lookup. Then reference that view from the lookup widget def instead of your actual users table.

-Steve

Thanks steve for your reply.
I think a SQL view is an interesting response.

And many thanks for your great product !