Getting documents which are having the same i_folder_id

Mpambani

Hi,

I've got a custom document type "tp_procurement" which is child of dm_document. I also have custom type "tp_procurement_support" which is a child of "tp_procurement".

I developed a TBO which is auto creating a folder when I'm creating "tp_procurement" and it moves document into the folder. Folder is using object_name of a newly created document. When I'm creating a folder I'm creating as custom type which is "tp_folder"

For my "tp_procurement" i've got "ord_number" and "file_ref" attributes. When a TBO fires off it uses counter to set "file_ref" field.

Once the folder is created and the "tp_procurement" type is moved inside the folder. I also going to create "tp_procurement_support" inside the folder.

My question:

How can I get "ord_number" field from "tp_procurement" and set it into auto created folder. Because I also have another field "ord_number" on "tp_folder".

I want them to have the same "ord_number".

Every time when I'm creating a document TBO will create a new folder using object_name of the document, then once the folder is created and the document is moved inside the folder, I will create "tp_procurement_support" inside the folder.

Meaning that I will have a list of folders and documents inside each folder.

Another question:

Which DQL statement or DFC code can I use to get objects which are sharing the same i_folder_id?

dnvhariprasad

try this..

select * from dm_document (all) where i_folder_id = 'xxxxxxx'ORselect * from dm_document (all) where i_folder_id like (select r_folder_path from dm_folder where r_object_id = 'your i folder id')