We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Working wallet.`action` IS NULL :
wallet.`action` IS NULL
query.select("COALESCE(SUM(IF(wallet.`fund_amount` > 0 AND wallet.`action` IS NULL, wallet.`fund_amount`, 0)),0)", "fund_in"); SQL Query will return: COALESCE(SUM(IF(wallet.`fund_amount` > 0 AND wallet.`action` IS NULL, wallet.`fund_amount`, 0)),0) AS fund_in
query.select("COALESCE(SUM(IF(wallet.`fund_amount` > 0 AND wallet.`action` IS NULL, wallet.`fund_amount`, 0)),0)", "fund_in");
SQL Query will return:
COALESCE(SUM(IF(wallet.`fund_amount` > 0 AND wallet.`action` IS NULL, wallet.`fund_amount`, 0)),0) AS fund_in
Not Working wallet.`action` != 'refund' :
wallet.`action` != 'refund'
query.select("COALESCE(SUM(IF(wallet.`fund_amount` > 0 AND wallet.`action` != 'refund', wallet.`fund_amount`, 0)),0)", "fund_in"); SQL Query will return with BACKTICK at first place: `COALESCE(SUM(IF(wallet.`fund_amount` > 0 AND wallet.`action` != 'refund', wallet.`fund_amount`, 0)),0)` AS fund_in
query.select("COALESCE(SUM(IF(wallet.`fund_amount` > 0 AND wallet.`action` != 'refund', wallet.`fund_amount`, 0)),0)", "fund_in");
SQL Query will return with BACKTICK at first place:
`COALESCE(SUM(IF(wallet.`fund_amount` > 0 AND wallet.`action` != 'refund', wallet.`fund_amount`, 0)),0)` AS fund_in
But i get the solution if you like, please make pull request of this changes:
Just add !' like above.
!'
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Working
wallet.`action` IS NULL
:Not Working
wallet.`action` != 'refund'
:But i get the solution if you like, please make pull request of this changes:
Just add
!'
like above.The text was updated successfully, but these errors were encountered: