Great, Massimo! 2011/12/26 Massimo Di Pierro <[email protected]>
> uploading to trunk > > On Dec 26, 11:42 am, Alexandre Andrade <[email protected]> > wrote: > > 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 > -- Atenciosamente Alexandre Andrade Hipercenter.com Classificados Gratuitos
