How can I filter for example all contacts that have same mobile and business phone. (or any other 2 columns in the contacts view, like same delivery and home address etc)?
Like
1 comments
21:12 May 15, 2019
Unfortunately, there are no such filters on the client end. However, you can create a view that will represent the needed data, then create an object in the bpm'online configuration that will represent the view. Then create a lookup in the "Lookups" section that will show data from the object.
This is how to create an object based on a view.
https://community.bpmonline.com/questions/how-create-view-object-bpm-on…
This is how to create a view that will display the needed data
create view VwContactPropDupl as with ContAddr (ContactId, AddressCount) as ( select ContactId, COUNT([Address]) from ContactAddress ca group by ContactId, [Address] ), ContComm (ContactId, CommCount) as ( select ContactId, COUNT(Number) from ContactCommunication group by ContactId, Number ) select c.Id [ContactId], COUNT(c.Id) [DuplicatesCount] from Contact c left outer join ContAddr ca on ca.ContactId = c.Id left outer join ContComm cc on cc.ContactId = c.Id where ca.AddressCount > 1 or cc.CommCount > 1 group by c.Id
Show all comments