I suspect you're after application.fapi.getContentObjects()<http://farcry.posterous.com/new-fapi-function-getcontentobjects> .
To get the options for each select list: <cfset qOptions = application.fapi.getContentObjects(typename="relatedType",lProperties="objectid,title",orderby="title") /> If the related types are linked through an array property on the primary record, you can quickly get results with this: <cfset qResult = application.fapi.getContentObjects(typename="primaryType",aRelated_all=lSelectedFilters,orderBy="title asc") /> This will return the objectid's of all records which are related to every selected filter objectid's. Blair On Thu, Aug 25, 2011 at 9:45 PM, Phillip R <[email protected]>wrote: > v6.07 - I sure someones done this before. > I've created a content type similar to dmNews and added a couple of > joins to other types. I found with the 3000+ entries categories ran > too slow. > I've also created a rule to list and paginate the content on a page. > Now here's the meat in the sandwich, from here I want to show dropdown > boxes so the user can filter the results based on the joined types. It > would appear that this would be easy to do with formtools and > filtering in the execute.cfm but I've had little success today and > can't find any examples like this. > Anyone have any suggestions? > > -- > 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] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
