Replies posted by RTGAKHILA

2 Replies

R
Do Gooder (Customer)
RTGAKHILADo Gooder (Customer)
asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

I need to synchronize the columns of a TABLE with those of a metadata view when a scheduled process executes at a specific time each day. How can I achieve this synchronization effectively?

i was not sure what exactly it is i just gone thorough fsm old conversion and kept it , if you know how to do that please guide me with an example

5
Shneor Cheshin
Superhero (Employee)
1 month ago
R
Do Gooder (Customer)
RTGAKHILADo Gooder (Customer)
asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

I need to synchronize the columns of a TABLE with those of a metadata view when a scheduled process executes at a specific time each day. How can I achieve this synchronization effectively?

i have a custom metadata view named ABC_VIEW in that i have columns like sms, phone, Id and i have two records in that view so i want to update that data with my table for example XYZ is my table name and it has keys mobile,sms,id so now i want to update that view data with this table every day at 8 AM for that i want to schedule a schedule process to run every day at required time so in that case i want xml body to acheive this here the xml that i wrote but its not working.<perform_mass_insert>  <parameters>    <select>      <hierarchy_select>        <primary_table>ABC_VIEW</primary_table>        <attrs>          <attr>ABC_VIEW.task_id</attr>          <attr>ABC_VIEW.sms_message</attr>          <attr>ABC_VIEW.phone_number</attr>        </attrs>        <from>          <table>ABC_VIEW</table>        </from>        <where />      </hierarchy_select>    </select>   

5
Shneor Cheshin
Superhero (Employee)
1 month ago

Badges

Show all badges
Terms & ConditionsCookie settings