Skip to main content
mradford
Contributor ⭐️⭐️⭐️
September 13, 2024
Solved

Dynamic JO Sync Issue when using Query Builder Source

  • September 13, 2024
  • 11 replies
  • 346 views

I am finding that the new Dynamic JO for Advanced Programs is not syncing properly after I make changes to the Query. 

I change the Query, Save and Sync, then review data but I still see values from prior iteration of the query changes and result set that says there is 2630 records. Even if I select Sync All, I do not see a new full replacement sync of the result set.

I end up having to go into Advanced Settings, and changing the Uniqueness criteria, syncing again, then changing the uniqueness back to what it was to get a full reset of the Sync. which results in 1209 records.  

Before I enter this as a bug, is there something I am missing on how to force a full replacement sync? 

Best answer by ebell

Hello Gainsight Admins!

This issue was identified as a bug; as of 3 hours ago, the fix has been applied to all affected Programs for US1, US2, & EU. Please check now to make sure you can sync your participants and makes changes to the Program! 

11 replies

dayn.johnson
VIP ⭐️⭐️⭐️⭐️⭐️
November 14, 2024

Dynamic JO needs feature parity with old JO. 

This doesn’t even BEGIN to cover the fact that dynamic JO doesn’t allow us to use multiple queries. This is one of the main blockers we have to migrating multiple triggered JOs to the new dynamic model, even if we were able to edit a query once a dynamic JO is published. (spoiler -- we can’t)

As much as I’d love to start using dynamic JO for every new program, I have to practice EXTREME caution with what I build there -- especially if it’ll be client-facing.

Even now, advanced JO is my faithful friend, and dynamic JO is his quirky companion who’s learning his way. There’s a lot to love with dynamic JO (action execution schedule and multiple branching paths, more than three CCs, evaluate steps before the first action, etc.) -- but it just doesn’t feel ready for prime time.

I know it’ll get there -- and I can’t wait for that day to come. 😀

 

Staff CS Content & Comms Manager, 2x Gainsight CS Ops Product Council Member