[SOLVED] Recommendation to upgrade
- galanopd
- OFFLINE
-
Platinum Member
- Posts: 332
- Thanks: 44
- Karma: 8
2 years 5 months ago - 2 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)
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...
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)
(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: 2 years 4 months ago by galanopd.
The following user(s) said Thank You: krileon
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.185 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- [SOLVED] Recommendation to upgrade