1 Reply Latest reply on Oct 26, 2009 6:28 PM by WestSide

    Using database and file results in search collection

    rhaddan Level 1
      I have a document management application that contains data about PDF documents in a database with a reference to the file name to access the PDF, like:

      id Name Number URL
      1 Doc Title 1 100-199 100-199.pdf
      2 Doc Title 2 100-287 100-287.pdf

      We currently search on the name and number from the database, but users want to search the contents of the PDF as well. The name and number are inside the PDF, but there is no metadata to return clean search results.

      Is there a way to combine the database query collection with the file search collection to create a single, searchable collection without manipulating the PDF files?

      Tags: cfsearch, cfcollection, cfindex, verity