[SOLVED] Issue with promotions, cbquery field and conditional

We upgraded joomla, CB, CBSubs and all plugins to the latest version this weekend.
Unfortunately we discovered an issue with one promotion that uses a cbquery field and a text field.

The promotion is now always active even though the condition is not met.

Query field: cb_currentyear: calculates the current year ("SELECT YEAR( current_date ) FROM `#__comprofiler` WHERE `id` = '[user_id]'")
Text field: cb_freemembshipin: administrator can enter a year in which the promotion is valid. Usually empty.

The promotion:
if value of cb_currentyear = value of cb_freemembshipin: apply a 100% discount

Current situation: even if the cb_freemembshipin field is empty, the promotion is applied.
We currently had to disable the promotion to prevent free discounts.

Your query isn't valid and is either erroring or just returning back empty value. You also don't need SQL to compare a field against current year. Use a condition from a substitution supported value against a field [cb:date format="Y" /] as the substitution. Example as follows.

Date A, Field A or Value A: Following CB field
CB Field A: cb_freemembshipin
Date B, Field B or Value B: Constant Value or String (CB substitutions can be used)
Value B: [cb:date format="Y" /]
Condition 1 (> for Dates): A = B (Value A is equal to Value B )

If you still want to use the query then the below should work, but I don't recommend doing an SQL query when it's not necessary.

Hi Krileon,

The query itself is working as you can see in the second screenshot : www.joomlapolis.com/media/kunena/attachments/529283/chrome_2017-05-21_20-44-42.png and the same promotion worked properly in the previous version (4.1.0,build.2016.12.31)

However, I changed it from a cbquery field to cb:date and that seems to work.

Kind regards