Hmm, looks like advanced search is not implemented for list:-type fields in
the grid.
On Monday, March 30, 2015 at 12:17:09 PM UTC-4, LoveWeb2py wrote:
>
> Hi Anthony,
>
> Yes I'm talking about the advanced search form in the grid.
>
> When you set a field type to list:string you no longer have the ability to
> select the field from the dropdown menu to create specific searches.
>
> Does that help to clarify?
>
> for example if I have Field('myFieldA', string')
>
> I can use the advanced search function in the SQLFORM.grid to say myFieldA
> contains "abc" AND myFieldA starts with "abc"
>
> When I change Field('myFieldA','list:string'), the field no longer appears
> in SQLFORM
>
>
>
> On Monday, March 30, 2015 at 12:12:15 PM UTC-4, Anthony wrote:
>>
>> Can you clarify the problem? Are you talking about the advanced search
>> form in the grid? What exactly is the issue?
>>
>> On Monday, March 30, 2015 at 11:29:54 AM UTC-4, LoveWeb2py wrote:
>>>
>>> Thank you, Anthony! This solved it.
>>>
>>> Should I use IS_LIST_OF() to enable the search function in SQLFORM?
>>>
>>> On Monday, March 30, 2015 at 10:35:19 AM UTC-4, Anthony wrote:
>>>>
>>>> Near the end of this section
>>>> <http://web2py.com/books/default/chapter/29/07/forms-and-validators#Validators>
>>>>
>>>> of the book, it notes that the only validators that work with list:-type
>>>> fields are IS_IN_SET(..., multiple=True), IS_IN_DB(..., multiple=True),
>>>> IS_NOT_EMTPY(), and IS_LIST_OF(). The latter can be used to apply
>>>> IS_ALPHANUMERIC() to each item in the list.
>>>>
>>>> Anthony
>>>>
>>>> On Monday, March 30, 2015 at 9:23:01 AM UTC-4, LoveWeb2py wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> When using a list:string my validators don't work like they used to on
>>>>> a regular string. For example if I had requires=IS_ALPHANUMERIC()
>>>>>
>>>>> when I input 1234568--/ I would receive an error
>>>>>
>>>>> but when I switched my field type from string to list:string I can now
>>>>> put anything in the field such as 1234568--/ and it works. I also noticed
>>>>> the SQLFORM.GRID does not allow you to specify that column in the
>>>>> dropdown
>>>>> list anymore. Why is there no exception for list handling?
>>>>>
>>>>
--
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/d/optout.
