Dear all,
we are using the following sync rule for sending some data to mobile
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_task_view</primary_table>
<from>
<table>c_wbs_task_view</table>
</from>
<attrs>
<attr>c_wbs_task_view.*</attr>
</attrs>
</hierarchy_select>
Related Query:
<hierarchy_select return_only_requested_attrs="true" max_rows='50000'>
<primary_table>c_wbs_task_view</primary_table>
<from>
<table>c_wbs_task_view</table>
</from>
<attrs>
<attr>c_wbs_task_view.*</attr>
</attrs>
</hierarchy_select>
We now face the issue that when changing or adding data in table c_wbs_task the new data / info is not synced to MC immediately. Even though the sync rule is defined as ‘Real time’.
Findings:
- When the task is re-assigned the new / changed data / info gets synced
- When defining the sync rule 'C_WBS_TASK_VIEW' as 'BATCH -Delta' and clicking on ‘sync’ the WBS gets synced
Therefore it looks like that the sync rule is working in general but is not working properly when defined with delivery method ‘real time’.
Do you know what causes this issue and how we can sort this out? Goal is to immediately send the new data / values to mobile.
Regards,
Thomas