Thanks a lot Paolo Caruccio!!
On Friday, October 25, 2013 6:39:46 PM UTC+5:30, Paolo Caruccio wrote:
>
> It's not necessary modify the code in gluon.
> You could replace the text input in the query panel. For example:
>
> 1) in db.py we define our table
>
> db.define_table('contact',
> Field('name'),
> Field('phone'))
>
> 2) in default.py we define our controller to create the grid
>
> def contacts():
> grid=SQLFORM.grid(db.contact, user_signature=False)
> table_name = 'contact'
> field_name = 'phone'
> element_id = 'w2p_value_%s-%s' % (table_name, field_name)
> custom_select = SELECT('', 'value1', 'value2', 'value3', _id=
> element_id)
> grid.element('input',_id=element_id, replace=custom_select)
> return locals()
>
> 3) we create our view default/contacts.html
>
> {{extend 'layout.html'}}
> <h1>Manage My Contacts</h1>
> {{=grid}}
>
> The code in step2 should put you on the right way.
>
> Il giorno venerdì 25 ottobre 2013 13:57:21 UTC+2, Sarbjit ha scritto:
>>
>> I was looking at the code in gucon.sqlform
>>
>> elif (field.type.startswith('reference ') or
>> field.type.startswith('list:reference ')) and \
>> hasattr(field.requires,'options'):
>> value_input = SELECT(
>> *[OPTION(v, _value=k)
>> for k,v in field.requires.options()],
>> **dict(_id=_id))
>> elif field.type == 'integer' or \
>> field.type.startswith('reference ') or \
>> field.type.startswith('list:integer') or \
>> field.type.startswith('list:reference '):
>> value_input =
>> SQLFORM.widgets.integer.widget(field,field.default,_id=_id)
>> else:
>> value_input = INPUT(
>> _type='text', _id=_id, _class=field.type)
>>
>>
>> Can this be enhanced to view Selection Dropdown with the values for all
>> the fields. I have not much experience in web2py, so can some one please
>> suggest a change here.
>>
>> On Wednesday, October 23, 2013 9:01:23 AM UTC+5:30, Sarbjit wrote:
>>>
>>> Can someone please help.
>>>
>>> On Tuesday, October 22, 2013 4:39:00 PM UTC+5:30, Sarbjit wrote:
>>>>
>>>> I am using GRID for displaying my database results. I want to use
>>>> search feature provided by GRID/SMARTGRID where users can build queries
>>>> and
>>>> get the results. I want to have a drop down field populated with the
>>>> values
>>>> defined in the database for the fields which are defined as strings in
>>>> database.
>>>>
>>>> In my case, some fields needs to have exact match and are used very
>>>> frequent for searching the records. Since it is very difficult to fill in
>>>> the exact name every time you are searching the records using that field,
>>>> I
>>>> want that for few fields, it should present a drop down.
>>>>
>>>> Can some one please suggest me on how on to do this.
>>>>
>>>> Thanks
>>>> Sarbjit
>>>>
>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
