Can't get selected r_object_id from Result List tied to an Advanced Repository Query in xcp

basinilya
basinilya
edited July 4, 2019 in Documentum #1

When you attach an "Advanced Repository Query" to a Result List and the DQL query has an "r_object_id" column, the expression widgets.results_list.selected_row.r_object_id is invalid and instead you have to use widgets.results_list.selected_row.id, but the main problem is that this expression returns something like "dql-queries/tst_list_folders/0b01e24080071d30" instead of just "0b01e24080071d30".

Why and how to overcome this?

The query is: select r_object_id, r_folder_path from dm_folder where folder ( '/Temp/SR4203056', descend )
The Result Set widget has two columns: col_r_object_id and col_r_folder_path.

Comments

  • DCTM_Guru
    DCTM_Guru
    #2

    We have observed that ARQ are very limited in their design. To answer your question, you can parse your string for just the ID after the slash and get what you want. Alternatively, don't use ARQ and just use real-time query.

  • basinilya
    basinilya
    #3

    I think the correct answer would be "use a column alias", like this:

    select r_object_id as r_object_id2, r_folder_path from dm_folder where folder ( '/Temp/SR4203056', descend )

    Seems to work.

Categories