How does this work when I want to get all dmNews items that have the categoryobjectid #i# in catNews, but also when have #i# and another categoryobjectid?
<cfset nieuws=application.fapi.getContentObjects(typename="dmNews", publishdate_lte=now(), expirydate_gte=now(), catNews_eq="#i#", orderby="publishdate DESC",maxRows="7")> I have some items with multiple catNews values. Op maandag 22 oktober 2012 11:42:54 UTC+1 schreef Blair McK het volgende: > > You can also do catFile_eq to return content with every specified > category. :) > > Plus, I added support for a all-purpose "categories" property (i.e. > categories_in, categories_eq), in case you can't remember what you called > the category property. > > Blair > > On Mon, Oct 22, 2012 at 7:24 PM, Geoff Bowers > <[email protected]<javascript:> > > wrote: > >> getcontentobjects() is like magic ;) >> >> GB >> >> >> On Monday, 22 October 2012, AJ Mercer wrote: >> >>> looks like Farcry is smart enough to work it out >>> >>> <cfset qryDocs = application.fapi.getContentObjects(typename="dmFile", >>> lProperties="*", catFile_in="#stObj.CATDOCUMENT#,123,456") /> >>> >>> select *, 'dmFile' as typename >>> from dbo.dmFile >>> where 1=1 >>> AND status in ('draft','pending','approved') >>> AND >>> objectid in ( >>> select objectid >>> from dbo.refCategories >>> where categoryid in ('05867140-1C04-11E2-9C64005056830000','123','456') >>> ) >>> >>> >>> On 22 October 2012 14:37, AJ Mercer <[email protected]> wrote: >>> >>>> I would like to know how to use getContentObjects() to filter a given >>>> category when the type may have multiple. >>>> >>>> Currently, the type (dmFile) is set up like this >>>> <cfproperty ftSeq="30" ftFieldset="Categorisation" name="catFile" >>>> type="string" hint="Flag to make file shared." required="no" >>>> ftLabel="Category" ftType="category" ftalias="dmfile" /> >>>> >>>> I am creating a rule which can select one category (may change >>>> to multiple later) >>>> >>>> How is getContentObjects() used to do this? >>>> >>>> >>>> -- >>>> >>>> *AJ Mercer* >>>> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org >>>> community="Open" /> <http://webonix.org> >>>> http://twitter.com/webonix >>>> Railo Community Manager<http://www.getrailo.org/index.cfm/community/team/> >>>> >>>> >>> >>> >>> -- >>> >>> *AJ Mercer* >>> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org >>> community="Open" /> <http://webonix.org> >>> http://twitter.com/webonix >>> Railo Community Manager<http://www.getrailo.org/index.cfm/community/team/> >>> >>> -- >>> 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] <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 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.
