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.
