3 Replies Latest reply on Nov 13, 2007 2:18 PM by Jeff Sweeney

    Google-like search

    Vidar Kvam
    Vidar Kvam Oct 1, 2007 1:51 PM
      Hi,

      How do I create a universal search in PDMWE? SolidWorks has told me to use search variable "History Text - Variable Value", but that does not seem to have any effect. It returns everything.

      I am surprised if noone has tried to do this before, because we all know how simple it is to search in Google or other engines. It ought to be just as simple in PDMWE, except we need to search through database records.
      • 635 Views
      • Categories: Data Management, Enterprise PDM
      • Tags:
        • Google-like search
          Joy Garon
          Joy Garon Employee Oct 1, 2007 8:26 PM (in response to Vidar Kvam)

          Hi Vidar -

           

          Why are you not taking advantage of full-textsearch? Isn't that what you really want?

          Look in the Installation guide for informationon Configuring theIndex Service on the SQL Server System.

           

           

          Regards,

          Joy

            • Google-like search
              Vidar Kvam
              Vidar Kvam Oct 1, 2007 9:04 PM (in response to Joy Garon)
              Hello Joy,

              Thanks for your reply. I am aware of the indexed search, but it seems odd to rely on that when you have an SQL Server. It is my understanding that indexing works on the vault's files, not the database.

              What we want is a lightning fast database search, independent of whether the actual files are indexed or not.
                • Google-like search
                  Jeff Sweeney
                  Jeff Sweeney Nov 13, 2007 2:18 PM (in response to Vidar Kvam)

                  The problem is the files themselves are not in SQL, just themeta data and pointers to the actual files. Unless it is in thedatacard, SQL has no knowledge of what data is actually in the fileitself.

                  An indexing search isn't terribly slow, I'd give it a try.