Solved

Part Usage Lookup is NOT showing all fields

  • 9 September 2022
  • 1 reply
  • 90 views
Shneor Cheshin
Rank
Userlevel 6
Badge +26

Hello 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!

icon

Best answer by Shneor Cheshin 9 September 2022, 04:02

View original

1 reply

Shneor Cheshin
Rank
Userlevel 6
Badge +26

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...

Reply


Terms & ConditionsCookie settings