Dynamics Community Forum Thread Details

Product Record Quick Search

We have a very peculiar problem reported by an end user. The issue is when user search product using quick search with English as default language then result set is different than when the user searches same product in quick search with the Italian language or any other language as default.

On further analysis found below is the fetchXML generated for quick search.

<fetch distinct="false" no-lock="false" mapping="logical" page="1" count="250" returntotalrecordcount="true" >
  <entity name="product" >
    <attribute name="name" />
    <attribute name="productnumber" />
    <attribute name="hierarchypath" />
    <attribute name="producttypecode" />
    <attribute name="description" />
    <attribute name="statecode" />
    <attribute name="processid" />
    <attribute name="name" />
    <attribute name="productnumber" />
    <attribute name="hierarchypath" />
    <attribute name="producttypecode" />
    <attribute name="description" />
    <attribute name="statecode" />
    <attribute name="productstructure" />
    <attribute name="iskit" />
    <attribute name="parentproductid" />
    <filter type="and" >
      <filter type="or" isquickfindfields="true" >
        <condition attribute="productnumber" operator="like" value="Laptop" />
        <condition attribute="name" operator="like" value="Laptop" />
      </filter>
    </filter>
    <order attribute="name" descending="false" />
    <link-entity name="workflow" to="processid" from="workflowid" link-type="outer" alias="processidworkflowworkflowid" >
      <attribute name="versionnumber" />
    </link-entity>
  </entity>
</fetch>

Also, on executing the FetchXML directly in XRMToolBox plugins depending upon the user language selected from UI the resultset differs.

I have tested the same on trial instance, depending upon the user language the resultset varies.

Has anyone faced similar issue? Any solution for it?

Thanks in advance.

Quick Links

Leaderboard