Question

WorkflowObjectQuery taking to long time to sync

  • 1 September 2023
  • 4 replies
  • 51 views
lopespetro
Rank
Userlevel 5
Badge +12

Hi All.

After publishing some survies (Object information Flow) linked to an object type, the entity is taking a long time to sync.

Is there any filter I can apply to improve the performance?

Tks

 

 

Br. Lopes

4 replies

P
Rank
Userlevel 1
Badge +4

@lopespetro we got an edit applied to the default where clause in the underlying view to speed up this query. We added a clause that only the surveys that were tied to the objects on work orders assigned to techs would sync.

lopespetro
Rank
Userlevel 5
Badge +12

@lopespetro we got an edit applied to the default where clause in the underlying view to speed up this query. We added a clause that only the surveys that were tied to the objects on work orders assigned to techs would sync.

Hi, @PIINKADAM . I did this clause and seens to get a better sync performance. I’m still evaluating to close this topic.

 

In my case, the eforms are linked just with the objects.

 

&0.DATE_CREATED >= SYSDATE

 

Br.

 

Lopes

 

Br. Lopes
P
Rank
Userlevel 1
Badge +4

Did you add the clause in the permission set filter or the underlying view?

lopespetro
Rank
Userlevel 5
Badge +12

Did you add the clause in the permission set filter or the underlying view?

A clause in the permission set filter.

Br. Lopes

Reply


Terms & ConditionsCookie settings