Relate Annotation with contract table

(0) Share

Report

Posted on by Community Member

Hello everyone!

I was wondering how I can relate attachments in the table AnnotationBase with thier own contracts in teh accountcontractbase.

I mean, the relation does exist beacuse, in the CRM interface, if I open the "notes" part of a contract I can find the notes attached to it. So, someway there's a link between the entities, which I'm not able to figure out.

Could you help me? I don't know it other details are useful. however, I'm avaibile to give you further information if needed.

Thanks a lot,

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

RE: Relate Annotation with contract table

No one can help? :(

Was this reply helpful? Yes No
Tim Dutcher 2,100 on at

Like (0)

Report

RE: Relate Annotation with contract table

I think you'll need to rephrase the question. You're seeing that there's a relationship between the annotation and contract entities, but it's not clear what you need to do with that information. Are you trying to write a query to get all notes for a contract?

Was this reply helpful? Yes No
Suggested answer

Kumar Viju 1,026 on at

Like (0)

Report

RE: Relate Annotation with contract table

Hi,

Assuming that you are writing SQL Query. You can try the following Join to retrieve notes for all the contracts. The Join is between AnnotationBase=> ObjectId and ContractBase =>ContractId

SELECT AnnotationBase.Subject, AnnotationBase.NoteText, ContractBase.ContractNumber

FROM AnnotationBase INNER JOIN

ContractBase ON AnnotationBase.ObjectId = ContractBase.ContractId

Note: If you planning to use this query for SSRS reports , Consider using FiltereView instead of Base Table's

Was this reply helpful? Yes No