Re: FarcryVerity - Collection Filter.

maybe take a look at cfindex custom[1..4]

I think Farcry uses the first 3, but 4 is free.
You can store your own value in here
then use that for your filtering.

It is just a text field, so if you have multiple things you want to store, you can use a list.

2009/6/25 Chris Roth <chris.roth@...>

Hoping someone on this list might be doing this already, as I seem to
be chaing my tail.

I am trying to figure out the best place to filter the collections
search (as well as displayed in the search form) based on Role.

Right now I am looking at  getCollections() in verityConfig.cfc

       <cffunction name="getCollections" access="private" output="false"
returntype="query">
               <cfset var qCollections=queryNew("configid, title, collectionname")>

               <cfquery datasource="#application.dsn#" name="qCollections">
               SELECT objectid AS configid, title, collectionname
               FROM farVerityCollection
               WHERE bEnableSearch = 1
               AND hostname = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#variables.hostname#" />
               AND collectionname LIKE <cfqueryparam cfsqltype="cf_sql_varchar"
value="#application.ApplicationName#/_%" /> escape '/'
               ORDER BY title
               </cfquery>

               <cfreturn qCollections />
       </cffunction>

--
AJ Mercer
Web Log: http://webonix.net