Solved

FSM Mobile - Service History not Up to date

  • 9 September 2020
  • 2 replies
  • 120 views

Userlevel 5
Badge +13

this is running FSM 5.7

it seems that the service history for request and tasks is delayed in getting to the mobile platform

i already checked the sync rules and it happens as a BATCH ALL at 9 PM every night. Nothing has been touched from the OOTB integration.

 

For example i am looking at a request that was closed 10 days ago yet still doesn't show on the mobile platform.

However when i initialize the history is immediately there.

How can i fix this so that it shows up at least on the daily sync?

 

icon

Best answer by jbernardo 12 January 2021, 15:35

View original

2 replies

Userlevel 5
Badge +13

Re-reading the definition of Batch-All vs Batch-Delta.

Sounds like we want it as Delta (where it is currently set to all)

what is the harm that could come from this syncing in real time though?

here is the inital query on the sync rule:

<hierarchy_select return_only_requested_attrs="true" max_rows="50000">
  <primary_table>MMA_REQUEST_HISTORY_VIEW</primary_table>
  <from>
    <table>MMA_REQUEST_HISTORY_VIEW</table>
    <table>PRODUCT</table>
    <table>PLACE</table>
    <table>PERSON</table>
  </from>
  <attrs>
    <attr>MMA_REQUEST_HISTORY_VIEW.*</attr>
  </attrs>
  <where>
    <join_constraint>
      <constraint>
        <left_operand>MMA_REQUEST_HISTORY_VIEW.PRODUCT_ID</left_operand>
        <operator>EQUI</operator>
        <right_operand>PRODUCT.PRODUCT_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>PRODUCT.PLACE_ID</left_operand>
        <operator>EQUI</operator>
        <right_operand>PLACE.PLACE_ID</right_operand>
      </constraint>
      <constraint>
        <left_operand>PLACE.PHY_SVC_GRP_A</left_operand>
        <operator>EQUI</operator>
        <right_operand>PERSON.PHY_SVC_GRP_A</right_operand>
      </constraint>
    </join_constraint>
    <data_constraint>
      <constraint>
        <left_operand>PERSON.PERSON_ID</left_operand>
        <operator>EQ</operator>
        <right_operand>{PERSON_ID}</right_operand>
      </constraint>
    </data_constraint>
  </where>
</hierarchy_select>

 

Here is the query under MMA_REQUEST_HISTORY_VIEW

 

SELECT        a.product_id, a.request_unit_id, a.request_id, a.place_id, a.req_type, a.req_status, a.created_dttm, a.request_end_dt, a.name, ISNULL(a.text, ' ') AS cust_prob_descr, a.person_id
FROM            (SELECT        ru.product_id, ru.request_unit_id, r.request_id, r.place_id, r.req_type, r.req_status, r.created_dttm, r.request_end_dt, pl.name, r.cust_prob_descr, t .person_id, text = STUFF
                                                        ((SELECT        ' ' + text
                                                            FROM            task_text t1
                                                            WHERE        t1.task_id = t .task_id AND t1.text_line_code = 'WP' FOR XML PATH('')), 1, 1, '')
                          FROM            request_unit ru LEFT OUTER JOIN
                                                    task t ON ru.request_id = t .request_id AND ru.request_unit_id = t .request_unit_id, request r, product p, place pl
                          WHERE        ru.request_id = r.request_id AND ru.product_id = p.product_id AND r.place_id = pl.place_id AND r.internal_type <> 'T' AND p.status = '1') a

Userlevel 5
Badge +13

the issue was replications was not running

Reply