thanks. On Sunday, February 23, 2014 12:34:58 AM UTC+2, Anthony wrote: > > If you make sure your URL vars have the same names as the associated table > fields, you can simplify further as follows: > > def eco: > my_content = db.table.created_by == auth.user.id > filter_query = reduce(lambda a, b: a & b, > [db.table[v] == request.vars[v] for v in request > .vars > if v in db.table.fields]) > filtered_list = db(my_content & filter_query).select(,,,,,) > return dict(filtered_list = filtered_list) > > or if you prefer loops: > > def eco: > filter_query = db.table.created_by == auth.user.id > for var in [v for v in request.vars if v in table.fields]: > filter_query &= db.table[var] == request.vars[var] > filtered_list = db(filter_query).select(,,,,,) > return dict(filtered_list = filtered_list) > > Anthony > > On Saturday, February 22, 2014 3:25:34 PM UTC-5, Avi A wrote: >> >> Great, thanks. the "moreover" idea is what i was missing. Yeah, I'll >> replace the args with vars url, thanks. >> >> >> On Saturday, February 22, 2014 9:36:58 PM UTC+2, Niphlod wrote: >>> >>> every >>> db.table.column == parameter >>> is something that further reduces the resultset (it's a "filter" >>> condition) >>> in case "parameter" is 0, just don't use that condition in the query ^_^ >>> >>> moreover, you can do >>> >>> filter_condition = (db.table.created_by == auth.user_id) >>> if ..... >>> filter_condition = filter_condition & (db.table.field_a == something) >>> .... >>> .... >>> >>> filtered_set = db(filter_condition).select() >>> >>> >>> PS: usually filters are more "manageable" with request.vars than >>> request.args() ... it's a little unconfortable to remember the order of the >>> filter and to specify 0 as the "ALL" parameter is counterintuitive .... >>> eco/0/1/0/6/0/0 sounds a lot more ugly than eco?b=1&d=6 >>> >>> On Saturday, February 22, 2014 7:28:33 PM UTC+1, Avi A wrote: >>>> >>>> Hi, >>>> Assuming I want to create an ajax query that will filter the results >>>> according to some data in fields: >>>> for example: ajax url: ... eco/1/6/4/5/3 >>>> >>>> def eco: >>>> my_content = db.table.created_by == auth.user.id >>>> query_a = db.table.field_a == request.args(0) >>>> query_b = db.table.field_b== request.args(1) >>>> query_c = db.table.field_c == request.args(2) >>>> query_d = db.table.field_d == request.args(3) >>>> query_e = db.table.field_e == request.args(4) >>>> >>>> filtered_list = db((my_content) & (query_a) & (query_b) & (query_c) >>>> & (query_d) & (query_e)).select(,,,,,) >>>> return dict(filtered_list = filtered_list) >>>> I guess, so far so good. >>>> >>>> Now if any arg == 0 , (for example: eco/2/0/0/0/3) I want it to skip >>>> that specific query. >>>> >>>> So I want to a chive something like that: >>>> if request.args(0) != 0: >>>> query_a = db.table.field_a == request.args(0) >>>> else: >>>> query_a = db.table.field_a == ALL >>>> if request.args(01) != 0: >>>> etc"... >>>> >>>> with what should I replace the ALL? or the else part? >>>> >>>> Thanks. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>>
-- 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/groups/opt_out.
