Question

advanced filtering options

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

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

 

Log in or register to comment