Have you thought of passing in your restrictions using the sqlwhere attribute instead of passing in an entire recordset?
Blair On Wed, Apr 27, 2011 at 6:43 AM, smika <[email protected]> wrote: > Hi, > > we've upgrade core to version 6.0.11, and suddenly filtering in admin > stopped working. I've found post and fix by Tomek, according to which > i need to replace <cfoutput>AND #i# LIKE '%#whereValue#%'</cfoutput> > by > <cfoutput>AND lower(#i#) LIKE '%#whereValue#%'</cfoutput> in > objectadmin.cfm under tags/formtools. > > Filtering start working only if there is no custom query defined. For > example: > <cfset stFilterMetaData = structNew() /> > > <cfset stFilterMetaData.title.ftValidation = "" /> > <cfquery name="latestArticles" datasource="#application.dsn#"> > Select > objectID,title,publishDate,secArticle,priority,bCommented,status from > ctArticle > where publishDate > Date_Add(now(), INTERVAL -90 DAY) > order by publishdate desc > </cfquery> > <cfset aCustomColumns = arraynew(1) /> > <cfset aCustomColumns[1] = structnew() /> > <cfset aCustomColumns[1].title = "Author 1"/> > <cfset aCustomColumns[1].webskin = "displayAuthor1" /> > <cfset aCustomColumns[2] = structnew() /> > <cfset aCustomColumns[2].title = "Author 2"/> > <cfset aCustomColumns[2].webskin = "displayAuthor2" /> > > <ft:objectAdmin > title="Article management" > typename="ctArticle" > ColumnList="title,publishDate,secArticle,priority,bCommented,status" > SortableColumns="title,publishDate,bCommented,status" > lFilterFields="title,publishDate" > qRecordSet="#latestArticles#" > stFilterMetaData="#stFilterMetaData#" > acustomColumns="#aCustomColumns#"/> > > > But if i remove my query along with qRecordSet in ft:objectAdmin > everything will work fine. > > Any ideas? > > Thanks, > Mika > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: [email protected] > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
