Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
10970 Tampilan

Hi guys,

I have 5 search criteria:

A, B, C, D, E

I whant to search (and i have tried diferent options) like in sql:  select id from obj_obj where A= 2 and B=3 and C=4 and (D=5 or E=6)

Basic idea is:

  •  when D is False :
    • than look for E = 6
  • or when E is False:
    • then look for D=5

Numbers are just for example.

I read some documentation and googling but without real success. I tried [('A','=', 2),('B','=', 3),('C','=', 4),'|',('D','=', 5),('E','=', 6)] but the solution is not working. if i try to add () like: [('A','=', 2),('B','=', 3),('C','=', 4),('|',('D','=', 5),('E','=', 6))] i receive and error: ValueError: Invalid term...

Can you please help?

Many thanks!

Avatar
Buang
Penulis

'=' updated. I missed when i placed the question. Sorry.

Jawaban Terbai

You have to put equal to D and E: [('A','=', 2),('B','=', 3),('C','=', 4),'|',('D','=', 5),('E','=', 6)] instead of [('A','=', 2),('B','=', 3),('C','=', 4),'|',('D','', 5),('E','', 6)].

 

Can you post the exact error?

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
1
Jun 25
36121
0
Feb 17
5387
3
Jul 25
4098
0
Mei 25
793
2
Mar 24
2028