There is a field called "Product" in our Sold-Product table.
Similarly there is a field called Product and another field called Sold Product available in the Entitlement Table.
The Value in the Sold Product field in the Entitlement table of an Account should uniquely refer to a Sold Product Record of the same Account.
Now I want to find the Entitlement records where the Product in the Entitlement Record of the Account is different from the Product in the SOLD Product Record of the Account. To find that I created the gadget as shown in the picture before. Though I set the query correctly the interpretation of the query is incorrect. Please see the correct ones underlined in green and the incorrect interpretation in red in the picture below.
(Basically it is interpreting as comparing the very same field "Sold-Product's Product with Sold-Product's Product" instead of "Sold-Product's Product with Product")
Do you know why it is interpreting the query incorrectly in the gadget?
But it works fine, in the query created in the Entitlement Table, though not in the gadget.
