python - Django Q filter not working as expected -

-

i created library style search form (where can add new lines further search, linking words and, or, , not, or not) allow them build search statements in form, tried turn q filter. reason, filter generate seems return if there or in it. (by 'or in it' mean the user selected or statement).

example: wanted create q filter objects name datafield , test value or material datafield , steel value.

when print out q created, get:

(and: (or: (and: ), (and: ('value__icontains', 'test'), ('represents__exact', <datafield: 3-name>)), (not (and: ('value__iexact', 'steel'), ('represents__exact', <datafield: 6-materials>)))))

reading statement, seems should work, doesn't , seems return everything.

this isn't have, example of form looks like: enter image description here

update: changed code resulting q statement instead:

(or: (and: ('value__icontains', 'er'), ('represents__exact', <datafield: 3-name>)), (not (and: ('value__iexact', 'er'), ('represents__exact', <datafield: 5-keywords>))))

or, in expanded form:

(or:     (and:         ('value__icontains', 'er'), ('represents__exact', <datafield: 3-name>)     ),     (not         (and:             ('value__iexact', 'er'), ('represents__exact', <datafield: 5-keywords>)         )     ) )

still, following code prints out in database:

    filtered = objects.filter(q)     print("filtered: ", filtered)

looks bug in way generating queryset.

reorganizing generated q statement, looks outermost and not have second expression.

(and:      (or:          (and: ),          (and:             ('value__icontains', 'test'),             ('represents__exact', <datafield: 3-name>)         ),          (not             (and:                 ('value__iexact', 'steel'),                 ('represents__exact', <datafield: 6-materials>)            )          )      ) )

also empty (and: ), pose problems too, have figure out way remove empty q object

p.s:this not complete answer, direction, because without looking @ code might hard figure out bug is.


Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more