Given a comparison between CDT_A (a:"richard",b:"nolan", c:&

Mark over 8 years ago

Given a comparison between CDT_A (a:"richard",b:"nolan", c:"Adam Smith",d:"(555) 334-7810") and CDT_B(first_name:"richard",last_name:"nolan",supervisor:"John Hancock",office_phone: "(555) 334-8761") where I consider one of these an authoritative source and the other local Appian data, is there a simple function I can use to compare these 2 CDT's and return a Boolean value on weather they're in sync or not?

Discussion posts and replies are publicly visible

Parents

0 Richard over 8 years ago

This is precisely what Mark is intending, a periodic query from the source system to collect an array of user profiles to check, then use one of the looping functions to determine which records should feed an update user profile Smart Service. The question is largely related to the rule that will be called to do the comparison.

We can craft something that uses a series of nested if statements to determine if a field has changed, and trigger a subsequent update. What we're hoping is that there's a more elegant solution using some other functions (e.g. some combination of choose() and wherecontains() or ...?

Cheers
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Richard over 8 years ago

This is precisely what Mark is intending, a periodic query from the source system to collect an array of user profiles to check, then use one of the looping functions to determine which records should feed an update user profile Smart Service. The question is largely related to the rule that will be called to do the comparison.

We can craft something that uses a series of nested if statements to determine if a field has changed, and trigger a subsequent update. What we're hoping is that there's a more elegant solution using some other functions (e.g. some combination of choose() and wherecontains() or ...?

Cheers
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data