2 Replies Latest reply on Dec 21, 2012 2:05 AM by liltbrockie

    Most efficient way to filter this portal?

    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 )