Re: getContentObjects() to filter type with multiple categories

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]> 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: farcry-dev-/[email protected]
>> To unsubscribe, email: farcry-dev+unsubscribe-/[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: farcry-dev-/[email protected]
> To unsubscribe, email: farcry-dev+unsubscribe-/[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: farcry-dev-/[email protected]
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry