I created a content material view that has a filter group utilizing Drupal Developer AND operator that’s ANDed with one other filter group utilizing Drupal Developer OR operator (see picture beneath)
Nonetheless, Drupal Developer question constructed is all AND operators and teams aren’t even utilized. Right here is Drupal Developer WHERE clause of Drupal Developer question:
WHERE ( ( // Content material: Kind (= On-demand) node__field_format.field_format_target_id = '29' ) ) AND ( ( ( // Content material: Revealed (= Sure) "node_field_data"."standing" = '1' ) AND ( // Content material: Content material sort (in Occasion, Coaching) "node_field_data"."sort" IN ('occasion', 'training_session') ) ) AND ( ( // (field_date_and_location: Paragraph) Paragraph: Date Vary (>= + 0 minutes) DATE_FORMAT((paragraphs_item_field_data_node__field_date_and_location__paragraph__field_date_range.field_date_range_value + INTERVAL -21600 SECOND), '%Y-%m-%dTpercentH:%i:%s') >= DATE_FORMAT(('2021-10-19T18:53:48' + INTERVAL -21600 SECOND), '%Y-%m-%dTpercentH:%i:%s') ) ) )
This question is not even remotely near what I’ve it configured as… By my configurations, I might count on Drupal Developer WHERE clause to be
WHERE ( ( // Content material: Revealed (= Sure) "node_field_data"."standing" = '1' ) AND ( // Content material: Content material sort (in Occasion, Coaching) "node_field_data"."sort" IN ('occasion', 'training_session') ) ) AND ( ( // Content material: Kind (= On-demand) node__field_format.field_format_target_id = '29' ) OR ( // (field_date_and_location: Paragraph) Paragraph: Date Vary (>= + 0 minutes) DATE_FORMAT((paragraphs_item_field_data_node__field_date_and_location__paragraph__field_date_range.field_date_range_value + INTERVAL -21600 SECOND), '%Y-%m-%dTpercentH:%i:%s') >= DATE_FORMAT(('2021-10-19T18:53:48' + INTERVAL -21600 SECOND), '%Y-%m-%dTpercentH:%i:%s') ) )
What’s Drupal Developer challenge with my configurations? I really feel this needs to be fairly an easy implementation however Drupal Developer diploma to which Drupal Developer question is inaccurate appears off..
