Is any relation between tables bbp_pdatt with any of the item table

[Former Member]

Hi all,

I have created shopping cart with 2 line items and each line item is having 2 attachments.

Now I am having the attachment data in table bbp_pdatt .and we have item data also.

I could not get the line item number or data in table bbp_pdatt.In table bbp_pdatt only attachment data exist.

I want to know for which line item the attachment belongs to.

Please tell me if there is any table having the attachment data as well as item data.in single table.

Thanks,

Prashanth.

[Former Member]

Hello ,

You can establish the link as follows:

Read CRMD_LINK table with GUID_HI = 'Item Guid' AND

OBJTYPE_SET '33'

The above will give you the result set which contains set guids (GUID_SET) values for attachment. This value can be joined with the (SET_GUID) of the BBP_PDATT table.

This will give you the attachments for the Shopping cart at item level.

Best Regards,

Sapna.

[Former Member]

Hi..

It is really helpful..

Thanks.