Skip to Content
0
Apr 17, 2014 at 01:43 PM

How to fetch email field in master agreement report?

24 Views

Hi All,

I am trying to fetch Supplier Primary Contact Email Id in "My Agreements and Contract Documents" report.

I tried adding below lines of code show in bold in query definition:

T5.EMAIL AS EMAIL

FROM

<%SCHEMA%>.FCI_MAS_VALUE_LIST_VALUE T3,

<%SCHEMA%>.FCI_CONTRACT T1 LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_INTERNAL_CAT T2 ON T1.INT_CAT_OBJECT_ID = T2.OBJECTID,

<%SCHEMA%>.FCI_MAS_CONTACT T5 LEFT OUTER JOIN <%SCHEMA%>.FCI_CONTRACT T6 ON (T5.OBJECTID = T6.CONTACT_OBJECT_ID)

But when I run the query, it gives wrong value in Email field.(different email Id's then primary contact email in master agreement)

Please guide me what should be right way to get the correct value.

Thanks,

Saloni