I have create view where it get an image banner from custom post type.
Using multilingual module I could translate all nodes. except the view. any way in how to achieve this?
I followed this answer but i cant make it work how do i translate a view page title
Steps I used:
- I have 3 products so I translated each product by clicking the button translate.
- I have set the filter in view to select based on selected language.
with the steps I used I can't get the translated products
I have done some debuging and I found the issue is because relationship is linked using
Here is the query that I found
SELECT * FROM node_field_data LEFT JOIN node__field_product_overview ON node_field_data.nid = node__field_product_overview.entity_id AND (node__field_product_overview.deleted = '0' AND node__field_product_overview.langcode = node_field_data.langcode) INNER JOIN paragraphs_item_field_data ON node__field_product_overview.field_product_overview_target_revision_id = paragraphs_item_field_data.revision_id WHERE (node_field_data.status = '1') AND (node_field_data.type IN ('product')))
node__field_product_overview.field_product_overview_target_revision_id = paragraphs_item_field_data.revision_id
is there way to modify query to use