Hi,
I am trying to get receiving ids that have inventory_adjusted set to Y (receiving items that are Posted - Full) to sync to mobile for a mobile customization that I am working on in FSM 6.
I have removed some extract restrictions I had previously for the Extract for the RECEIVING table and am getting all the columns for Receiving.
I have attached screenshots of the extract and sync rule for receiving.
Please see the ownership, initial, and related queries for Receiving below:
Ownership Query:
<hierarchy_select>
<primary_table>receiving_ownership_view</primary_table>
<from>
<table>receiving_ownership_view</table>
</from>
<attrs>
<attr>receiving_ownership_view.person_id</attr>
</attrs>
<where>
<data_constraint>
<constraint>
<left_operand>receiving_ownership_view.receiving_id</left_operand>
<operator>eq</operator>
<right_operand>{RECEIVING_ID}</right_operand>
</constraint>
</data_constraint>
</where>
</hierarchy_select>
Initial Query:
<hierarchy_select return_only_requested_attrs="true" max_rows="50000">
<primary_table>RECEIVING</primary_table>
<from>
<table>RECEIVING</table>
<table>RECEIVING_DETAIL</table>
<table>RECEIVING_UNIT</table>
<table>RECEIVING_OWNERSHIP_VIEW</table>
<table>SHIPMENT</table>
</from>
<attrs>
<attr>RECEIVING.*</attr>
<attr>RECEIVING_DETAIL.*</attr>
<attr>RECEIVING_UNIT.*</attr>
<attr>SHIPMENT.*</attr>
</attrs>
<where>
<data_constraint>
<constraint>
<left_operand>RECEIVING_OWNERSHIP_VIEW.PERSON_ID</left_operand>
<operator>eq</operator>
<right_operand>{PERSON_ID}</right_operand>
</constraint>
<constraint>
<left_operand>RECEIVING.INVENTORY_ADJUSTED</left_operand>
<operator>eq</operator>
<right_operand>N</right_operand>
</constraint>
</data_constraint>
<join_constraint>
<constraint>
<left_operand>RECEIVING.RECEIVING_ID</left_operand>
<operator>eq</operator>
<right_operand>RECEIVING_OWNERSHIP_VIEW.RECEIVING_ID</right_operand>
</constraint>
<constraint>
<left_operand>RECEIVING.RECEIVING_ID</left_operand>
<operator>left_outer</operator>
<right_operand>RECEIVING_DETAIL.RECEIVING_ID</right_operand>
</constraint>
<constraint>
<left_operand>RECEIVING.RECEIVING_ID</left_operand>
<operator>left_outer</operator>
<right_operand>RECEIVING_UNIT.RECEIVING_ID</right_operand>
</constraint>
<constraint>
<left_operand>RECEIVING.SHIPMENT_ID</left_operand>
<operator>left_outer</operator>
<right_operand>SHIPMENT.SHIPMENT_ID</right_operand>
</constraint>
</join_constraint>
</where>
</hierarchy_select>
Related Query:
<hierarchy_select return_only_requested_attrs="true" max_rows='50000'>
<primary_table>RECEIVING</primary_table>
<from>
<table>RECEIVING</table>
<table>RECEIVING_DETAIL</table>
<table>RECEIVING_UNIT</table>
<table>SHIPMENT</table>
</from>
<attrs>
<attr>RECEIVING.*</attr>
<attr>RECEIVING_DETAIL.*</attr>
<attr>RECEIVING_UNIT.*</attr>
<attr>SHIPMENT.*</attr>
</attrs>
<where>
<data_constraint>
<constraint>
<left_operand>RECEIVING.RECEIVING_ID</left_operand>
<operator>eq</operator>
<right_operand>{RECEIVING_ID}</right_operand>
</constraint>
</data_constraint>
<join_constraint>
<constraint>
<left_operand>RECEIVING.RECEIVING_ID</left_operand>
<operator>left_outer</operator>
<right_operand>RECEIVING_DETAIL.RECEIVING_ID</right_operand>
</constraint>
<constraint>
<left_operand>RECEIVING.RECEIVING_ID</left_operand>
<operator>left_outer</operator>
<right_operand>RECEIVING_UNIT.RECEIVING_ID</right_operand>
</constraint>
<constraint>
<left_operand>RECEIVING.SHIPMENT_ID</left_operand>
<operator>left_outer</operator>
<right_operand>SHIPMENT.SHIPMENT_ID</right_operand>
</constraint>
</join_constraint>
</where>
</hierarchy_select>
Where is it restricting the receiving items to only sync the ones that have inventory_adjusted to Y? Is this in the client code? Please let me know if any additional information is needed.
Thanks,
Sylvia