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
