Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I have installed draggable View and it working fine in view but when i copy that query from view and use as db_query in my code, its not working properly query is given below
SELECT node.nid AS nid, node.title AS node_title, node.status AS node_status, draggableviews_structure.weight AS draggableviews_structure_weight
FROM
{node} node
LEFT JOIN {draggableviews_structure} draggableviews_structure ON node.nid = draggableviews_structure.entity_id AND draggableviews_structure.view_name = 'view_videos' AND draggableviews_structure.view_display = 'page' AND draggableviews_structure.args = '{\"status\":\"1\",\"title\":\"\"}'
WHERE (( (node.type IN ('suno_video')) AND (node.status = '1') ))
ORDER BY draggableviews_structure_weight ASC
LIMIT 50 OFFSET 0
This query working fine in MySQl and Views but not ordering properly in my code...
Thanks for advance...
Comments