Using keywords inside a list as query argument

[stefano.menci]

Perhaps I’m wrong, but considering the lack of understanding I thought we should make sure we are talking about the same thing.

Looking at your first snippet:

@koollucian.2012

Code Sample:

  {
    'name': r['name'],
    'employed': r['employed'],
  }
  for r in app_tables.people.search()
]

It looks like you are trying to build a list searching one item at a time.

I just want to make sure that you understand that you can get a list of people that match your search criteria in one shot. You only need one search.

This for example would give you the list of people named ‘joe’ with employed==True:

list_of_rows = app_tables.people.search(name='joe', employed=True)

Using simple argument values like name='joe', you will find all the rows with an exact match.

Using q in the arguments allows to use more complex criteria, like greater than a number, starting with a text, containing a text, etc.

Here is an example of some advanced queries.