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]<javascript:_e({},
> 'cvml', '[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] <javascript:_e({}, 'cvml',
> '[email protected]');>
> To unsubscribe, email:
> [email protected]<javascript:_e({}, 'cvml',
> 'farcry-dev%[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
