Question

Real time sync of a New Table

  • 22 June 2021
  • 2 replies
  • 100 views

Userlevel 1
Badge +2

Hi All,

I need a real time sync of a New table which contains multiple info for same task_id as below.

TASK_ID,  SERVICE_NO, ENTITY,  STATUS 

123, A1, Audit login, Success 

123, A1, Modem install, Success

123,A1, Working Status,  Fail 

143, B1, Audit login, Fail

143,B2, Modem install,  Success 

143, B2, Woking Status, Fail

 

Finding

How can we sync this in real time to the mobile whenever there's a update in FSM DB.


This topic has been closed for comments

2 replies

Userlevel 7
Badge +24

Hi @Gudulbaba,

You can create a new sync rule on the sync rule screen. If you set its refresh value to real time this will then resend whenever the subject table is changed within any filters you set on the sync rule.

Kind regards,

Lee Pinchbeck

Userlevel 3
Badge +6

Hi @Lee Pinchbeck ,

Please help me in this.

I have created a new sync rule ‘TASK_CONFORMITY_CHECK’ and made the Delivery method as Real Time. 

and added the initial query as

</hierarchy_select> return_only_requested_attrs=”true” max rows=”50000”>

<primary_table>TASK_CONFORMITY_CHECK</primary_table>

<from>

<table>TASK_CONFORMITY_CHECK</table>

</from>

<attrs>

<attr>TASK_CONFORMITY_CHECK.*</attr>

</attrs>

</hierarchy_select>

 

I have not added any ownership and related query. 

The data are not synced to the mobile in mobile. Once initialized it is synced to mobile. 

Could you please help me in this what to do to get the real time synced data.