CRM web UI issue with Attachemnts query and dynamic query

125 Views

Hi ,

I need to create new assignment block(AB) in accounts page. This AB should display Attachemnts related to account in project and acitvites .

I found query CMDocumentFinder and dynamic query CMAdvDocumentFinder in component set CM which suitable for my requiement .

I provide INSTID = ORER GUID

TYPEID = BUS2000111

CATID = BO as input parameters .

I got error message "Enter at least one (more) search criterion for performance reasons" . same error is coming when i use the dynamic query.

when I provide CREATED_BY = userid , results are coming .

My intenstion here is get the attachement details by order guid only.

I found FM CRM_ICSS_GET_ATTACHMENTS to get the attachment details , but this FM does not have enough output fields which suits my requiement.

my output should to be , attachement name (not file name ) ,attachement type , created by , created at.

and Alink should provide to the attachement name ,when choose on link it should open the attahcement.

Please suggest

(1) how run the query/dynamic query.

(2) suggest tables /views/FM to full fill my requiremnt name , mainly attachement name etc.

Thanks and regards

Naveen