Excellent. Exactly what I wanted.
Thanks a lot @cdbaron 

On Saturday, July 17, 2021 at 6:22:36 PM UTC+5:30 cdbaron wrote:

> You should not use db.ftp_simplivity_log_db.log_path.readable = False
> You have to use db.ftp_simplivity_log_db.log_path.listable = False
>
> If you want to cancel the search for any field in the table you can use 
> db.table.any_fielfd.searchable = Flase 
>
> El viernes, 16 de julio de 2021 a las 17:56:43 UTC+2, [email protected] 
> escribió:
>
>> With the following code, I can search log_path info
>>
>>     db.ftp_simplivity_log_db.log_path.readable = True
>>     ftp_simplivity_log_grid = SQLFORM.grid(db.ftp_simplivity_log_db,
>>                                            searchable=True,
>>                                            advanced_search=False,
>>                                           
>>  orderby=~db.ftp_simplivity_log_db.log_date,
>>                                            sortable=True,
>>                                            details=False,
>>                                            csv=False,
>>                                            paginate=50,
>>                                           
>>  maxtextlengths={'ftp_simplivity_log_db.log_date': 100, 
>> 'ftp_simplivity_log_db.log_path': 300},
>>                                            links=[lambda row: A('SimplifY 
>> --> ' + row.log_path, _href=URL('download_simplivity_log', args=row.id), 
>> _class='btn btn-light')])
>>
>>
>> [image: with_log_path.jpg]
>>
>> But changing to False
>> db.ftp_simplivity_log_db.log_path.readable = False
>>
>> [image: without_log_path.jpg]
>>
>> The output looks clean, but search is not able to search the log_path,
>>
>> [image: without_log_path_search.jpg]
>>
>> Hence the question I have is,
>> Is there a way to keep
>> db.ftp_simplivity_log_db.log_path.readable = True
>> so search can work and still be able to hide it in the actual grid 
>> display ?
>>
>

-- 
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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/7dd81179-201e-4a86-977f-b82a842024e7n%40googlegroups.com.

Reply via email to