/Python/Django query multiple conditions

Django query multiple conditions

from django.db.models import Q

 	criterion1 = Q(UID=request.user.id) #any query you want
    criterion2 = Q(FID=user.id) #any query you want
    criterion3 = Q(FID=request.user.id) #any query you want
    criterion4 = Q(UID=user.id) #any query you want
    areTheyFriends = Friends.objects.filter(criterion1 & criterion2 | criterion3 & criterion4) # use `&` and `|` logical operators

Similar codes

91 votes135 views6 answers
Conda create environment python 3
Python
1 vote160 views2 answers
Python write request must be str not bytes
Python
2 votes142 views2 answers
Flask 'export' is not recognized as an internal or external command, operable program or batch file.
Python
23 votes192 views6 answers
Decorators in python
Python
0 vote158 views1 answer
How to make print float value without scientific notation in dataframe in jupyter notebook
Python
1 vote162 views3 answers
How to get today weekday in python
Python
-1 vote139 views1 answer
How to transcode a video in python using ffmpeg
Python
-1 vote137 views1 answer
Extracting values in pandas
Python
1 vote152 views1 answer
How to slice dataframe based on daterange in pandas
Python
1 vote148 views1 answer
Find the value counts for the column 'your_column'
Python