Hi all
I have recently moved from SQLite to Postgres, I've had to change all the
'groupby' to 'distinct'. However, I'm also using the 'groupby; command in
the SQLgrids, but this does not have a distinct option.
Does anyone know of a workaround? Example code below
def re_standardise_taxon():
query = ((db.study_meta_data.publication_info_id == publication_info_id) &
(db.gbif_taxon.taxon_id == db.study_meta_data.taxon_id))
form = SQLFORM.grid(query,
field_id=db.study_meta_data.id,
groupby=db.study_meta_data.taxon,
fields=[db.study_meta_data.taxon,
db.study_meta_data.taxon_id],
headers={'study_meta_data.taxon': 'Original Taxon Name',
'study_meta_data.taxon_id': 'Replacement Taxon
Name'},
maxtextlength=200, searchable=True,
advanced_search=False,
deletable=False, editable=False,
details=False, create=False, csv=False
)
return locals()
--
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.
