4 Replies Latest reply on Jun 16, 2017 2:15 PM by Doug Castell

    How do end users search by Web Site?

    Rookie

      I don't see a way to search by customer's web site.  Is there something that I am missing or is it a feature that Goldmine is missing?

        • 1. Re: How do end users search by Web Site?
          JDymon Apprentice

          USE A SQL QUERY LIKE THE FOLLOWING

           

          SELECT  C1.accountno, c1.company, c1.contact, c1.phone1, cs.contsupref

          FROM  CONTACT1 AS C1 (NOLOCK)

          JOIN (SELECT DISTINCT ACCOUNTNO, contsupref

                FROM CONTSUPP CTS

               WHERE (CTS.RECTYPE = 'P' AND CTS.CONTACT = 'Web Site' AND  CTS.CONTSUPREF like '%www.1stdirect.com%'))  CS

                ON CS.AccountNo = C1.AccountNo ORDER BY C1.CONTACT

           

           

          Just change  www.1stdirect.com to the website url you want to search for.

          • 2. Re: How do end users search by Web Site?
            Rookie

            Unfortunately, I expected this to be the answer.  I'd prefer not to have end-users executing raw SQL queries.  It's not a user-friendly thing to expect end-users to do.

            • 3. Re: How do end users search by Web Site?
              JErste Specialist

              Universal Search is an option with a filter on the 'Found In' column to limit results to 'Contacts: Detail'

              1 of 1 people found this helpful
              • 4. Re: How do end users search by Web Site?
                Doug Castell Expert

                Right-click on the website link on the contact record and select LOOKUP.

                 

                In that window, it's useful to note that you can search for a value like %caste to return www.castellcomputers.com and/or http://www.castellcomputers.com/ etc. etc.  The percent symbol is a wildcard value, basically, meaning 'anything here'.  Pre-pending the search term allows you to do a contains style search. 

                 

                I agree that this should behave, instead, similarly to what happens when you right-click->lookup on the e-mail address 'field', but, until then, it is what it is.

                1 of 1 people found this helpful