Hi:
I'm wanting to perform a query that does the following:
Link:
--------
Opportunity to SalesOrder to SalesOrderDetail to Product
Filter:
--------
Opportunity (by Stepname plus 2 custom fields)
Return:
-----------
SalesOrder and a sumed field from the Product of each item within the
SalesOrderDetail
I've not been able to use filtered views in the past as I'm accessing
the data via a bespoke web front end and I can't rely on windows
authentication. I have not found a way of performing an inpersonation
within the sql connection string of a crm user, therefore I'm after a
way of doing this using the RetrieveMultiple request.
Hope the above makes sense, appreciate any help
Jon Risbey