Hello everyone,

we are having a problem with the sync rule of a table:

Ownership Query:

<hierarchy_select>
 <primary_table>c_task_assignment_view</primary_table>
 <from>
  <table>c_task_assignment_view</table>
 </from>
 <attrs>
  <attr>c_task_assignment_view.person_id</attr>
 </attrs>
 <where>
  <data_constraint>
   <constraint>
    <left_operand>c_task_assignment_view.task_id</left_operand>
    <operator>eq</operator>
    <right_operand>{task_id}</right_operand>
   </constraint>
  </data_constraint>
 </where>
</hierarchy_select>

Initial Query:

<hierarchy_select return_only_requested_attrs="true" max_rows="50000">
  <primary_table>C_WBS_CODE_TASK</primary_table>
  <attrs>
    <attr>C_WBS_CODE_TASK.*</attr>
    <attr>C_WBS_TASK_VIEW.*</attr>
  </attrs>
  <from>
    <table>C_WBS_CODE_TASK</table>
    <table>C_WBS_TASK_VIEW</table>
  </from>
  <where>
     <data_constraint>
        <constraint>
          <left_operand>C_WBS_CODE_PERSON_VIEW.person_id</left_operand>
          <operator>eq</operator>
          <right_operand>{person_id}</right_operand>
        </constraint>
    </data_constraint>
    <join_constraint>
      <constraint>
        <left_operand>C_WBS_CODE_TASK.task_id</left_operand>
        <operator>eq</operator>
        <right_operand>C_WBS_CODE_PERSON_VIEW.task_id</right_operand>
      </constraint>
    </join_constraint>
    <join_constraint>
      <constraint>
        <left_operand>C_WBS_TASK_VIEW.task_id</left_operand>
        <operator>equi</operator>
        <right_operand>C_WBS_CODE_TASK.task_id</right_operand>
      </constraint>
    </join_constraint>
  </where>
</hierarchy_select>

Related Query:

<hierarchy_select return_only_requested_attrs="true" max_rows="50000">
  <primary_table>C_WBS_CODE_TASK</primary_table>
  <attrs>
    <attr>C_WBS_CODE_TASK.*</attr>
    <attr>C_WBS_TASK_VIEW.*</attr>
  </attrs>
  <from>
    <table>C_WBS_CODE_TASK</table>
    <table>C_WBS_TASK_VIEW</table>
  </from>
  <where>
      <data_constraint>
        <constraint>
          <left_operand>C_WBS_CODE_TASK.task_id</left_operand>
          <operator>eq</operator>
          <right_operand>{task_id}</right_operand>
        </constraint>
     </data_constraint>
     <join_constraint>
      <constraint>
        <left_operand>C_WBS_TASK_VIEW.task_id</left_operand>
        <operator>equi</operator>
        <right_operand>C_WBS_CODE_TASK.task_id</right_operand>
      </constraint>
    </join_constraint>
  </where>
</hierarchy_select>

The idea is, that if the table C_WBS_CODE_TASK changes (adding row, changing row, deleting row) the table and the corresponding view C_WBS_TASK_VIEW will get synchronized to the mobile device in real time.So far, the ownership query correctly sends only relevant rows. Furthermore, new rows in C_WBS_CODE_TASK get synchronized in real time and C_WBS_TASK_VIEW also shows the new data correctly on the mobile client.

But if entries get deleted or changed in the SC/WC, the data still stays available on the mobile client, means the table does not get correctly updated.

As a side information, the edditing of the C_WBS_CODE_TASK table only happens on the SC/WC. On WC data is only shown.

Has anybody an idea how these changes can get synchronized to the mobile client in real time? I suspect it referes to the “Related Query”, but i am not sure what i am missing.

with kind regards,
Michael