[SOLVED] Recommendation to upgrade

galanopd
OFFLINE
Posts: 375
Thanks: 49
Karma: 8

3 years 5 months ago - 3 years 4 months ago #326896 by galanopd

Replied by galanopd on topic [SOLVED] Recommendation to upgrade

Actually not so fine yet...

So the Plan has
PLAN
Dates / CB Fields Comparisons
Following CB field
CB Field A (a query field)
Date B, Field B or Value B (Constant value or String)
Value B (e.g. 3)
Condition 1 (> for Dates) A>B

FIELD (query)

Code:

(SELECT REGEXP_SUBSTR(rev.`xml`, '[0-9]+')
 FROM `#__cbsubs_subscriptions` AS sub, `#__vreview_review` AS rev
  WHERE REGEXP_SUBSTR(rev.`xml`, '[0-9]+') = sub.`user_id`
)

Query seems to be working fine www.db-fiddle.com/f/LVCvymt2uyKrz4sjbEzUC/4

Any idea?

EDIT: I had to go for a walk (under the rain) to realize that a basic query condition (AND rating) was missing! Please disregard...

Last edit: 3 years 4 months ago by galanopd.

The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon