Dropdown dependent problem

QuestionsDropdown dependent problem
Azam asked 5 years ago

Hello, Abu Gufran!
When using dropdown dependent with 'or' statement in sql query, i do not get the required (filtered) records. Can you fix it? If I will remove 'or' statement in sql query, everything is ok!

4 Answers
Abu Ghufran answered 5 years ago

Hi,

Azam, can you send me sample code snippet. Currently i am facing problem in regenerating this case.

Azam answered 5 years ago

Hi, Abu Gufran!
If you will change (for example) in your demo code for dropdown dependent query to:

$g->select_command = "SELECT id, invdate, invheader.client_id, amount, note FROM invheader
INNER JOIN clients on clients.client_id = invheader.client_id where amount=1000 or amount<500
";

you will see that it will work incorrect. The 'or' statement in that query causes abnormal result. Thank in advance!

Abu Ghufran answered 5 years ago

Change following …
where amount=1000 or amount<500

to

where (amount=1000 or amount<500)

By this, it will not interfere with the search where clause additions.

$g->select_command = "SELECT id, invdate, invheader.client_id, amount, note FROM invheader
INNER JOIN clients on clients.client_id = invheader.client_id where (amount=1000 or amount<500)
";

Azam answered 5 years ago

Thanks! It works!

Your Answer

3 + 17 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!