AvinashHiremat2
7 years agoQrew Trainee
Quickbase php api - how to group multiple conditions in do query
I need to query 2 multi select fields -
same field should be OR condition and the other field should be in AND condition
As of now, it's working like
(fid1 = value1 OR fid1 = value2 AND fid2 = value3 OR fid2 = value4)
I would like the query like
(fid1 = value1 OR fid1 = value2) AND (fid2 = value3 OR fid2 = value4)
array(0) {
["fid"]=>
int(7)
["ev"]=>
string(2) "EX"
["cri"]=>
string(16) "Field Operations"
}
[2]=>
array(1) {
["fid"]=>
int(7)
["ev"]=>
string(2) "EX"
["cri"]=>
string(7) "Finance"
["ao"]=>
string(2) "OR"
}
[3]=>
array(2) {
["fid"]=>
int(7)
["ev"]=>
string(2) "EX"
["cri"]=>
string(17) "Global Operations"
["ao"]=>
string(2) "OR"
}
[4]=>
array(3) {
["fid"]=>
int(7)
["ev"]=>
string(2) "EX"
["cri"]=>
string(30) "Human Resources/Communications"
["ao"]=>
string(2) "OR"
}
same field should be OR condition and the other field should be in AND condition
As of now, it's working like
(fid1 = value1 OR fid1 = value2 AND fid2 = value3 OR fid2 = value4)
I would like the query like
(fid1 = value1 OR fid1 = value2) AND (fid2 = value3 OR fid2 = value4)
array(0) {
["fid"]=>
int(7)
["ev"]=>
string(2) "EX"
["cri"]=>
string(16) "Field Operations"
}
[2]=>
array(1) {
["fid"]=>
int(7)
["ev"]=>
string(2) "EX"
["cri"]=>
string(7) "Finance"
["ao"]=>
string(2) "OR"
}
[3]=>
array(2) {
["fid"]=>
int(7)
["ev"]=>
string(2) "EX"
["cri"]=>
string(17) "Global Operations"
["ao"]=>
string(2) "OR"
}
[4]=>
array(3) {
["fid"]=>
int(7)
["ev"]=>
string(2) "EX"
["cri"]=>
string(30) "Human Resources/Communications"
["ao"]=>
string(2) "OR"
}