apollo7
asked on
We are working on converting SQL SSRS reports to FetchXML
Dynamics 365 9.1,
We are working on converting SQL SSRS reports to FetchXML for the Dynamics 365 Online environment. We have completed most of a report but still have the following to convert:
SQL
select Value
from FilteredStringMap
where FilteredViewName ='FilteredFEI_nanoportdemo'
and attributename = 'fei_nano_nnplocation'
FETCH
<fetch mapping="logical" version="1.0">
<entity name="StringMap">
<attribute name="Value" />
<filter>
<condition attribute="ViewName" operator="eq" value="FEI_nanoportdemo" />
<condition attribute="attributename" operator="eq" value="fei_nano_nnplocation" />
</filter>
</entity>
</fetch>
We can query the Stringmap in SQL and can see it Fetchxml Builder but cant link the stringmap/option set to the report
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER