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()
widget type lookup with custom SELECT
3 posts
• Page 1 of 1
widget type lookup with custom SELECTHi,
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()
Re: widget type lookup with custom SELECTOne 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
Then in your lookup widget field def
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
Re: widget type lookup with custom SELECTThanks steve for your reply.
I think a SQL view is an interesting response. And many thanks for your great product !
3 posts
• Page 1 of 1
Who is onlineUsers browsing this forum: No registered users and 9 guests |