+28Hello Community,
I have configured the part used lookup in mobile to retrieve additional fields from PRODUCT and MODEL_STRUCTURE tables.
The issue is that I cannot see all the fields I am trying to show in the UI,
This is my query in mobile vs. SQL tool. Identical as far as I can see
I added a specific part id just to demo my issue
The results
2 fields are missing and NOT showing - product.product_id, product.external_system_id.
Any ideas?
Cheers!
Best answer by Shneor Cheshin
Found the issue in the sync rule for PRODUCT.
I commented the data constraint and now the values are showing as expected
<hierarchy_select>
...
...
<data_constraint>
...
<!--constraint>
<left_operand>PRODUCT.MODEL_ID</left_operand>
<operator>not_null</operator>
</constraint-->
</data_constraint>
</where>
</hierarchy_select>
Work in progress...
+28Found the issue in the sync rule for PRODUCT.
I commented the data constraint and now the values are showing as expected
<hierarchy_select>
...
...
<data_constraint>
...
<!--constraint>
<left_operand>PRODUCT.MODEL_ID</left_operand>
<operator>not_null</operator>
</constraint-->
</data_constraint>
</where>
</hierarchy_select>
Work in progress...
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.