Question

Mobile Syncing and refreshing Issues


Userlevel 2
Badge +7

Hi guys,

 

I have an issue with Mobile Syncing. This is for the IFS mobile App Version: 6.18.8173.7168

 

When I reinitialize, the ‘All’ Filter that normally shows all jobs, will become blank. When I reinitialize again, everything shows up as per normal.

 

Also, in the ‘Team Task’ filter, it is not updating immediately when a task is created and assigned to a team. It requires to reselect the team and save to “refresh” the sync?

 

Will a refresh client script in Job List screen work? Or is some changes to Sync Rules required?

 

This is the Task Sync Rules FYI.

<hierarchy_select return_only_requested_attrs="true" max_rows="50000">
  <primary_table>TASK</primary_table>
  <from>
    <table>TASK</table>
    <table>PLACE</table>
    <table>PLACE_ADDRESS</table>
    <table>ADDRESS</table>
    <table>CONTACT</table>
    <table>REQUEST</table>
    <table>C_REQ_PLACE_INFO_VIEW</table>
    <table>REQUEST_CONTACT</table>
    <table>REQUEST_TEXT</table>
    <table>REQUEST_UNIT</table>
    <table>RECEIVING</table>
    <table>RECEIVING_UNIT</table>
    <table>PRODUCT</table>
    <table>C_PRODUCT_STRUCTURE_VIEW</table>
    <table>MODEL</table>
    <table>PART_NEED</table>
    <table>SHIPMENT</table>
    <table>TIME_CLOCK_EVENT</table>
    <table>ESCALATION</table>
    <table>CONTRACT</table>
    <table>CONTR_TYPE</table>
    <table>TASK_ATTACHMENT</table>
    <table>ATTACHMENT</table>
    <table>WARRANTY_COVERAGE</table>
    <table>TIME_COMMIT</table>
    <table>QUALITY</table>
    <table>TASK_ASSIGNMENT_VIEW</table>
    <table>TASK_STEPS</table>
    <table>TASK_STEPS_ATTACHMENT</table>
    <table>ATTACHMENT_ALIAS</table>
    <table>TASK_UNIT</table>
    <table>ATTACHMENT_ALIAS2</table>
    <table>ATTACHMENT_ALIAS3</table>
    <table>C_BOL_DETAILS_VIEW</table>
  </from>
  <attrs>
    <attr>TASK.*</attr>
    <attr>PLACE.*</attr>
    <attr>PLACE_ADDRESS.*</attr>
    <attr>ADDRESS.*</attr>
    <attr>CONTACT.*</attr>
    <attr>REQUEST.*</attr>
    <attr>C_REQ_PLACE_INFO_VIEW.*</attr>
    <attr>REQUEST_TEXT.*</attr>
    <attr>REQUEST_CONTACT.*</attr>
    <attr>REQUEST_UNIT.*</attr>
    <attr>RECEIVING.*</attr>
    <attr>RECEIVING_UNIT.*</attr>
    <attr>PRODUCT.*</attr>
    <attr>C_PRODUCT_STRUCTURE_VIEW.*</attr>
    <attr>MODEL.*</attr>
    <attr>PART_NEED.*</attr>
    <attr>SHIPMENT.*</attr>
    <attr>TIME_CLOCK_EVENT.*</attr>
    <attr>ESCALATION.*</attr>
    <attr>CONTRACT.*</attr>
    <attr>CONTR_TYPE.*</attr>
    <attr>TASK_ATTACHMENT.*</attr>
    <attr>ATTACHMENT.*</attr>
    <attr>WARRANTY_COVERAGE.*</attr>
    <attr>TIME_COMMIT.*</attr>
    <attr>QUALITY.*</attr>
    <attr>TASK_STEPS.*</attr>
    <attr>TASK_STEPS_ATTACHMENT.*</attr>
    <attr>ATTACHMENT_ALIAS.*</attr>
    <attr>TASK_UNIT.*</attr>
    <attr>ATTACHMENT_ALIAS2.*</attr>
    <attr>ATTACHMENT_ALIAS3.*</attr>
    <attr>C_BOL_DETAILS_VIEW.*</attr>
  </attrs>
  <where>
    <data_constraint>
      <constraint>
        <left_operand>task_assignment_view.person_id</left_operand>
        <operator>eq</operator>
        <right_operand>{PERSON_ID}</right_operand>
      </constraint>
      <and />
      <parens>
        <constraint>
          <left_operand>task.status</left_operand>
          <operator>eq</operator>
          <right_operand>OP</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.status</left_operand>
          <operator>eq</operator>
          <right_operand>CO</right_operand>
        </constraint>
      </parens>
      <and />
      <parens>
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>OPEN</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>ASSIGNED</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>COMMITTED</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>ACCEPTED</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>SKIP</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>ENROUTE</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>ARRIVED</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>IN PROCESS</right_operand>
        </constraint>
        <or />
        <constraint>
          <left_operand>task.task_status</left_operand>
          <operator>eq</operator>
          <right_operand>RECEIVED</right_operand>
        </constraint>
        <or />
        <parens>
          <constraint>
            <left_operand>task.task_status</left_operand>
            <operator>eq</operator>
            <right_operand>COMPLETED</right_operand>
          </constraint>
          <and />
          <constraint>
            <left_operand>task.user_def14</left_operand>
            <operator>eq</operator>
            <right_operand>Y</right_operand>
          </constraint>
        </parens>
      </parens>
      <and />
      <constraint>
        <left_operand>receiving.inventory_adjusted</left_operand>
        <operator>eq</operator>
        <right_operand>N</right_operand>
      </constraint>
      <and />
      <constraint>
        <left_operand>TIME_CLOCK_EVENT.PERSON_ID</left_operand>
        <operator>eq</operator>
        <right_operand>{PERSON_ID}</right_operand>
      </constraint>
    </data_constraint>
    <join_constraint>
      <constraint>
        <left_operand>TASK.REQUEST_ID</left_operand>
        <operator>equi</operator>
        <right_operand>REQUEST.REQUEST_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>REQUEST.REQUEST_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>C_REQ_PLACE_INFO_VIEW.REQUEST_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.PLACE_ID_CUST</left_operand>
        <operator>left_outer</operator>
        <right_operand>PLACE.PLACE_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>PLACE.PLACE_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>PLACE_ADDRESS.PLACE_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>PLACE_ADDRESS.ADDRESS_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>ADDRESS.ADDRESS_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.CONTACT_SEQUENCE</left_operand>
        <operator>left_outer</operator>
        <right_operand>CONTACT.CONTACT_SEQUENCE</right_operand>
      </constraint>
      <constraint>
        <left_operand>REQUEST.REQUEST_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>REQUEST_CONTACT.REQUEST_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>REQUEST.REQUEST_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>REQUEST_UNIT.REQUEST_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>REQUEST.REQUEST_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>PART_NEED.REQUEST_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.PRODUCT_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>PRODUCT.PRODUCT_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>PRODUCT.PRODUCT_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>C_PRODUCT_STRUCTURE_VIEW.FIRST_PRODUCT</right_operand>
      </constraint>
      <constraint>
        <left_operand>PRODUCT.MODEL_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>MODEL.MODEL_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.REQUEST_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>SHIPMENT.REQUEST_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>SHIPMENT.SHIPMENT_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>RECEIVING.SHIPMENT_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>TASK.TASK_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>TIME_CLOCK_EVENT.FOREIGN_KEY_NUM1</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.TASK_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>ESCALATION.FOREIGN_KEY_NUM1</right_operand>
      </constraint>
      <constraint>
        <left_operand>REQUEST_UNIT.CONTRACT_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>CONTRACT.CONTRACT_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>REQUEST_UNIT.REQUEST_UNIT_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>QUALITY.REQUEST_UNIT_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>CONTRACT.CONTR_TYPE</left_operand>
        <operator>left_outer</operator>
        <right_operand>CONTR_TYPE.CONTR_TYPE</right_operand>
      </constraint>
      <constraint>
        <left_operand>REQUEST_UNIT.WTY_COV_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>WARRANTY_COVERAGE.WTY_COV_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.TASK_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>TIME_COMMIT.TASK_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.TASK_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>TASK_ATTACHMENT.TASK_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK_ATTACHMENT.ATTACHMENT_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>ATTACHMENT.ATTACHMENT_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.TASK_ID</left_operand>
        <operator>equi</operator>
        <right_operand>TASK_ASSIGNMENT_VIEW.TASK_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>REQUEST.REQUEST_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>REQUEST_TEXT.REQUEST_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.TASK_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>TASK_STEPS.TASK_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK_STEPS.TASK_STEP_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>TASK_STEPS_ATTACHMENT.TASK_STEP_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK_STEPS_ATTACHMENT.ATTACHMENT_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>ATTACHMENT_ALIAS.ATTACHMENT_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.TASK_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>TASK_UNIT.TASK_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.USER_DEF_NUM1</left_operand>
        <operator>left_outer</operator>
        <right_operand>ATTACHMENT_ALIAS2.ATTACHMENT_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.USER_DEF_NUM2</left_operand>
        <operator>left_outer</operator>
        <right_operand>ATTACHMENT_ALIAS3.ATTACHMENT_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>TASK.REQUEST_ID</left_operand>
        <operator>left_outer</operator>
        <right_operand>C_BOL_DETAILS_VIEW.REQUEST_ID</right_operand>
      </constraint>
    </join_constraint>
  </where>
</hierarchy_select>


0 replies

Be the first to reply!

Reply