I was wondering if it is possible to create a single records from two different

bonniet over 9 years ago

I was wondering if it is possible to create a single records from two different sources, for example one process and an entity. Say for example I have a process that creates performance assessments and I want a record that can display the active assessments and the completed assessments as simply assessments. Both would display the same information but one would be coming from an active process and the other from the data store that we are writing the completed assessments to? Is this even possible and if so can someone point me in the direction of how it would be done?

Discussion posts and replies are publicly visible

Parents

0 Stewart Burchell
Appian Employee
over 9 years ago

Hi Bonnie - having re-read your original post, it might make more sense to ALWAYS write an entry to the data source that represents your 'entity', and simply change the value in a column that represents the 'state' of that instance. That way you'd simply be delivering a single Entity-backed record that encompassed 'All Performance Assessments' which would be way more simple than trying to merge two queries from two different types of data source. You'd then be able to add a facet that would allow you to separate 'Active' from 'Completed'. [if there's a good reason why you can't take this approach we can re-visit your original request]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stewart Burchell
Appian Employee
over 9 years ago

Hi Bonnie - having re-read your original post, it might make more sense to ALWAYS write an entry to the data source that represents your 'entity', and simply change the value in a column that represents the 'state' of that instance. That way you'd simply be delivering a single Entity-backed record that encompassed 'All Performance Assessments' which would be way more simple than trying to merge two queries from two different types of data source. You'd then be able to add a facet that would allow you to separate 'Active' from 'Completed'. [if there's a good reason why you can't take this approach we can re-visit your original request]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data