Whoops your right, " status = 'approved' " forgot there where more then 2 status labels...
If you post your suggestion I will vote it :) Op zondag 24 maart 2013 01:53:05 UTC+1 schreef Jeff Coughlin het volgende: > > Well you want to add something like: > and status = 'approved' > > Otherwise you'll get pending items as well. > > If you want to put in a request to have that changed, then most likely it > will be an argument in the method. I was thinking about asking if I could > modify getRelatedContent() in core to allow filtering by status. It > wouldn't be difficult to do. > > -- > Jeff Coughlin > > On Mar 23, 2013, at 20:40, Marco van den Oever > <[email protected]<javascript:>> > wrote: > > Thanks Jeff, I couldn't find the search method as I forgot it is part of > the fandango skeleton, and there it was... > > <cfcomponent displayname="Simple Search" extends= > "farcry.core.packages.forms.forms" > fualias="search" hint="A simple search which does a SQL LIKE filter > on dmHTML content."> > > > <cffunction name="search" returntype="query"> > <cfargument name="q" type="string" default=""> > > <cfset var qResults = ""> > > <cfquery name="qResults" datasource="#application.dsn#"> > SELECT objectid, typename, SUM(relevance) AS relevance > FROM ( > SELECT objectid, 'dmHTML' AS typename, 10 AS relevance > FROM dmHTML WHERE lower(title) LIKE <cfqueryparam cfsqltype= > "cf_sql_varchar" value="%#lcase(arguments.q)#%"> > UNION > <cfif application.dbtype eq "mssql2005"> > <!--- cast ntext fields as nvarchar for sql server > ---> > SELECT objectid, 'dmHTML' AS typename, 7 AS relevance > FROM dmHTML WHERE lower(CAST(teaser AS nvarchar(max))) LIKE <cfqueryparam > cfsqltype="cf_sql_varchar" value="%#lcase(arguments.q)#%"> > UNION > SELECT objectid, 'dmHTML' AS typename, 5 AS relevance > FROM dmHTML WHERE lower(CAST(body AS nvarchar(max))) LIKE <cfqueryparam > cfsqltype="cf_sql_varchar" value="%#lcase(arguments.q)#%"> > <cfelse> > SELECT objectid, 'dmHTML' AS typename, 7 AS relevance > FROM dmHTML WHERE lower(teaser) LIKE <cfqueryparam cfsqltype= > "cf_sql_varchar" value="%#lcase(arguments.q)#%"> > UNION > SELECT objectid, 'dmHTML' AS typename, 5 AS relevance > FROM dmHTML WHERE lower(body) LIKE <cfqueryparam cfsqltype= > "cf_sql_varchar" value="%#lcase(arguments.q)#%"> > </cfif> > ) results > GROUP BY objectid, typename > ORDER BY relevance DESC > </cfquery> > > <cfreturn qResults> > </cffunction> > > </cfcomponent> > > I assume I have to add a " AND status NOT LIKE 'draft' " statement? > > And if this is correct add this as an improvement ticket to the fandango > skeleton? > > Op zaterdag 23 maart 2013 23:59:10 UTC+1 schreef Jeff Coughlin het > volgende: >> >> Between the pagination i have custom code. >> >> How do I prevent the draft from showing up? >> >> >> For best performance, you should filter based on the status field in the >> original query. >> >> 1. What version of FarCry are you using? >> 2. What database (and version) are you using? >> 3. What does the search() method (code) look like (that's where the >> status filter will likely go depending on what's in there)? >> 4. I'm assuming you're not using Solr or Verity? Just querying the DB >> directly? >> >> -- >> Jeff Coughlin >> >> On Mar 23, 2013, at 6:50 PM, Marco van den Oever <[email protected]> >> wrote: >> >> Hi all, I see that a draft item is showing up in the search results, I >> use this code: >> >> <cfsetting enablecfoutputonly="true"> >> <!--- @@displayname: Simple Search Type Body ---> >> <!--- @@author: Justin Carter ([email protected]) ---> >> >> <cfimport taglib="/farcry/core/tags/webskin" prefix="skin"> >> <cfimport taglib="/farcry/core/tags/admin" prefix="admin" /> >> >> <cfparam name="url.q" default=""> >> >> <!--- do search ---> >> <cfif url.q neq "Zoeken"> >> <cfset stLocal.qResults = queryNew("objectid")> >> <cfif len(url.q)> >> <cfset stLocal.qResults = search(url.q)> >> </cfif> >> </cfif> >> >> <!--- <cfdump var="#stLocal.qResults#"> ---> >> <!--- display search message ---> >> <cfif url.q neq "Zoeken" and len(url.q) gt 3> >> <cfoutput> >> <p>Er <cfif stLocal.qResults.recordCount eq "0">zijn geen >> zoekresultaten<cfelseif stLocal.qResults.recordCount eq "1">is één >> zoekresultaat<cfelse>zijn #stLocal.qResults.recordCount# zoekresultaten >> </cfif> gevonden voor "#url.q#".</p> >> </cfoutput> >> <cfelse> >> <cfoutput> >> <p>Vul een zoekterm (meer dan 3 karakters) in het zoekveld en >> druk op enter of klik op het vergrootglas.</p> >> </cfoutput> >> </cfif> >> >> >> <!--- <cfdump var="#stLocal.qResults#"><cfabort> ---> >> >> >> <!--- display results ---> >> <cfif url.q neq "Zoeken" and len(url.q) gt 3> >> >> >> <!--- THIS MEANS PAGINATE ---> >> <skin:pagination query="#stLocal.qResults#" typename="dmNews" >> paginationID="searchNews" recordsPerPage="10" pageLinks="10" r_stobject= >> "data"> >> >> Between the pagination i have custom code. >> >> How do I prevent the draft from showing up? >> >> Thanks! >> >> -- >> 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 because you are subscribed to the Google Groups >> "farcry-dev" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] <javascript:> > To unsubscribe, email: [email protected] <javascript:> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry > --- > You received this message because you are subscribed to the Google Groups > "farcry-dev" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- 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 because you are subscribed to the Google Groups "farcry-dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
