FarcryVerity - Collection Filter.

[Chris Roth-2]

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>
--~--~---------~--~----~------------~-------~--~----~
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev@...
To unsubscribe, email: farcry-dev+unsubscribe@...
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---

[AJ Mercer]

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

--~--~---------~--~----~------------~-------~--~----~
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev@...
To unsubscribe, email: farcry-dev+unsubscribe@...
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---

[AJ Mercer]

forgot link
    http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_i_06.html

2009/6/25 AJ Mercer <ajmercer@...>

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

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

--~--~---------~--~----~------------~-------~--~----~
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: farcry-dev@...
To unsubscribe, email: farcry-dev+unsubscribe@...
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---