Hi all,
I am trying to run a DQL query that selects all the documents and orders it by r_version_label.
What happens is it duplicates the same documents and returns multiple rows for same document with numeric version number as well as CURRENT string.
I am totally new to DQL and unable to figure out how to order by version.
i tried ordering by object_id and position etc.nothing helped.
this is how my query looks.
SELECT r_object_id,object_name,a_content_type,i_folder_id,r_lock_owner,r_modify_date,r_version_label,r_full_content_size FROM deal_document(all) WHERE r_object_id in (SELECT r_object_id FROM deal_document WHERE folder(ID('0b0f424f80195b8b'),descend) ENABLE (RETURN_RANGE 1 10 10 'r_version_label ASC')) ORDER BY r_version_label asc;
