I could solve most of my problems using the new fantastic smartgrid.
But i have 2 sugestions for the developers:
in sqlhtml.py
Line 1368 :
from
_value="query",_type="button",_id="w2p_query_trigger",
to:
_value=T("query"),_type="button",_id="w2p_query_trigger",
to allow i18n
and
line 1925:
from
' ',
to:
' > ',
to correct separation between first and second steps
Regards.
Alexandre Andrade
2011/12/26 Alexandre Andrade <[email protected]>
> Hi Jim,
>
> Just to know your example of query worked to me.
>
> Thanks again.
>
> Alexandre Andrade
>
>
> 2011/12/26 Alexandre Andrade <[email protected]>
>
>> Hi Jim,
>>
>> Thanks for reply.
>>
>> 1. I will try your example of query/contraints.
>> 2. about represent/lambda issue: i get it working with a workaround, but
>> I think it could be easier.
>> 3. about linked_tables: it works with grid/list, but in view/edit it
>> shows all linked tables. I have some cases I dont want the user see all
>> linked tables, just one or two of them.
>>
>> Regards.
>>
>>
>> 2011/12/26 Jim Steil <[email protected]>
>>
>>> I don't know why you're having the problems you are.
>>>
>>> Regarding the lambda issue, I too have noticed the change, but thought
>>> it worked throughout web2py to always pass the row argument. However, I'm
>>> no longer using crud so I wouldn't notice that.
>>>
>>> Linked tables are working for me. What do you mean when you say it
>>> doesn't work for view and edit?
>>>
>>> Constraints has been working for me - here is a sample:
>>>
>>> # Build query
>>> queries = []
>>> constraints = None
>>> if searchText and searchText .strip() != '':
>>> queries.append(db.asset.description.contains(searchText))
>>> if assetTypeId and assetTypeId > 0:
>>> queries.append(db.asset.assetTypeId==assetTypeId)
>>> if len(queries) > 0:
>>> query = reduce(lambda a,b:(a&b),queries)
>>> constraints={'asset':query}
>>>
>>> # Setup search forms
>>> searchForms = {'asset':assetSearch}
>>>
>>> grid = SQLFORM.smartgrid(db.asset, fields=fields,
>>> constraints=constraints, orderby=orderby,
>>> create=create, details=details,
>>> editable=editable, deletable=deletable,
>>> csv=False,
>>> search_widget={'asset':assetSearch},
>>> searchable=True,
>>> paginate=15, maxtextlength=45)
>>>
>>> All of these work ok for me. Possibly your use cases are different that
>>> mine. Could you share some detail about what you are seeing that isn't
>>> working for you?
>>>
>>> -Jim
>>>
>>>
>>> On 12/26/2011 8:23 AM, Alexandre Andrade wrote:
>>>
>>> I'm trying to use smartgrid in a app, and could be sucessful in most
>>> parts.
>>> But there are some things stopping, so I'm here asking for help
>>>
>>> 1. The old way of use lambda in represent was
>>>
>>> represent = lambda field: get_atividade(field)
>>>
>>> and now, in some parts of smartgrid and book V4, look as:
>>>
>>> represent = lambda field,row : get_atividade(field)
>>>
>>> the last works with the grid, but not in form to view and crud.
>>>
>>> I solved this using a if statement, but I think that could be
>>> implemented one way to do use represent without setting it every time.
>>>
>>>
>>>
>>> 2. The linked_tables settings works for grid, but not for form (view and
>>> edit) . I looked at code (gluon/sqlhtml.py#..smartgrid)
>>> , and found this:
>>>
>>> if linked_tables is None or referee in linked_tables:
>>> field.represent = lambda
>>> id,r=None,referee=referee,rep=field.represent: A(callable(rep) and rep(id)
>>> or
>>> id,_class=trap_class(),_href=URL(args=request.args[:nargs]+['view',referee,id],
>>> user_signature=user_signature))
>>>
>>> i think referee is a way to know if is viewing or edit form, but it
>>> always show all the linked_tables, so linked_tables settings is uselless.
>>> I think it could remove the second part of if to properly use the settings
>>> way.
>>>
>>> 3. I need to show only some registers in a grid. But whiles the docs
>>> talk about the constraints settings, i cant find a example of query to make
>>> it work. A workaround was use the keywords (as in user made query, but it
>>> has the disavantage of show the query in the search field.
>>> Could someone provide a example of using constraints?
>>>
>>>
>>> --
>>> Atenciosamente
>>>
>>>
>>> Alexandre Andrade
>>> Hipercenter.com Classificados Gratuitos
>>>
>>>
>>
>>
>> --
>> Atenciosamente
>>
>>
>> Alexandre Andrade
>> Hipercenter.com Classificados Gratuitos
>>
>
>
>
> --
> Atenciosamente
>
>
> Alexandre Andrade
> Hipercenter.com Classificados Gratuitos
>
--
Atenciosamente
Alexandre Andrade
Hipercenter.com Classificados Gratuitos
