If you build a custom collection in Verity, you can use one of the custom fields in CFINDEX to write a list of matching keywords and values for each document. That should work, but I'm not sure I like that solution from an architectural viewpoint. I would rather have metadata in a structured format and index against the structured format. Rather than build a table for each document type, you could build a table for documents, a table for document types, and build a table for document properties. Properties could be different by document type, and each individual document could have its own values for each document property. That's the way the Spectra application was architected, and it is one of the things about Spectra I still use in legacy Spectra apps I maintain.
>I've got a project right now where we're taking scanned documents and >running it through an OCR program. The documents also have keywords >attached to them. The keyword types (ie. location_state, >meeting_date, meeting_type) are different depending on the document >type (ie. contract, meeting minutes, invoice). > >I need to make an interface that will both search keywords and full >text searches on the documents. Both will be done exclusively, not at >the same time. The full text search doesn't seem to be a problem with >the verity engine. The keyword search bugs me. I could make a table >for each document type, but that doesn't seem very "clean". Is there >a way to use these keywords in verity? > >Also, if one of the keywords is a date, can verity do searches like >"date < 1/1/2005"? > >-- >G-mail must not realize I'm and anti-social nerd, it keeps telling me >to "Invite 50 friends to Gmail" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196022 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54