- 🇨🇦Canada joelpittet Vancouver
I am quite sure I fixed that in the commit from 🐛 List is incorrect if multiple values present per row Fixed let me know if that is incorrect
I used Views Selective Filters in Drupal 7 with no problem. Now I try to use it in D8 or D9 (because I have not found such an extention in D8/ D9). I don't understand how the use is different from D7. I've tried even with simple case. No result. I have error such as:
No valid values found on filter: Content: Marque.
or
Selective query filter must have corresponding field added to view with Administrative Name set to "Content : Marque (field_marque_occasion) (selective)" and Base Type "field_marque_occasion"
so I change Admistrative name : No result.
Or
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node__field_marque_occasion.field_marque_occasion' in 'where clause': SELECT node_field_data.langcode AS node_field_data_langcode, node_field_data.created AS node_field_data_created, node_field_data.nid AS nid FROM {node_field_data} node_field_data LEFT JOIN {node__field_marque_occasion} node__field_marque_occasion ON node_field_data.nid = node__field_marque_occasion.entity_id AND node__field_marque_occasion.deleted = :views_join_condition_0 WHERE (node_field_data.status = :db_condition_placeholder_1) AND (node_field_data.type IN (:db_condition_placeholder_2)) AND (node__field_marque_occasion.field_marque_occasion IN (:db_condition_placeholder_3)) ORDER BY node_field_data_created DESC LIMIT 11 OFFSET 0; Array ( [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => occasion [:db_condition_placeholder_3] => 109 [:views_join_condition_0] => 0 )
I don't know where and why the query construct a column as "node__field_marque_occasion.field_marque_occasion".
My client was very happy with the dynamic selective Query in D7 and now I've had to construct its site in D9. Can somebody help me please, I'm working on this since 3 days and don't find on the web any solution. Thank you
Closed: duplicate
1.0
Documentation
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I am quite sure I fixed that in the commit from 🐛 List is incorrect if multiple values present per row Fixed let me know if that is incorrect