liltbrockie

Most efficient way to filter this portal?

Discussion created by liltbrockie on Dec 20, 2012
Latest reply on Dec 21, 2012 by liltbrockie

Hi there... I have a enquiry system where by a portal shows a list of matching addresses based on what is entered in the enquriy for the customer details. A portal shows the matching addresses. Is this the most efficient code for the filtered portal calc?

 

( IsEmpty ( Enquiries::Name Last ) or PatternCount ( AddressC ALL::SurnameD; Enquiries::Name Last))

and

( IsEmpty ( Enquiries::Addr Address ) or PatternCount ( AddressC ALL::AddressD; Enquiries::Addr Address ))

and

( IsEmpty ( Enquiries::Name First ) or PatternCount ( AddressC ALL::FirstNameD; Enquiries::Name First))

and

( IsEmpty ( Enquiries::Addr Town ) or PatternCount ( AddressC ALL::TownD; Enquiries::Addr Town))

and

( IsEmpty ( Enquiries::Addr County ) or PatternCount ( AddressC ALL::CountyD; Enquiries::Addr County))

and

( IsEmpty ( Enquiries::Addr Post Code ) or PatternCount ( AddressC ALL::PostcodeD; Enquiries::Addr Post Code ))

and

( IsEmpty ( Enquiries::Company ) or AddressC ALL::Company= Enquiries::Company )

Outcomes