Blog

Brad Wood

October 10, 2012

Spread the word


Share your thoughts

 

Dynamic Finders are brand new to ColdBox 3.5.3 which will be released shortly.  I usually give tips on released functionality, but we're real excited about our new Grails-inspired functionality and invite you to check it out on our development line to give them a spin.
 
Dynamic Finders basically let you create very readable code with dynamic method names that describe the criteria being used to to load or count ORM entities.  The best part is, you don't have to write any of the code-- just call the dynamic method and ColdBox does the rest!
 
Any ColdFusion ORM entity that extends our ActiveEntity component as well as any base or virtual entity service will all support these dynamic finder methods.  Each method must start with "findBy", "findAllBy", or "countBy" and can contain any number of properties and conditionals.
 
Here's some examples:
user = entityNew("User").findByLastName("Majano");
users = entityNew("User").findAllByLastNameLike("Ma%");

property name="userService" inject="entityservice:userService";
users = userService.findAllByLastLoginBetween( "01/01/2010", "01/01/2012" );
users = userService.findAllByLastLoginGreaterThan( "01/01/2010" );
count = userService.countByLastLoginGreaterThanAndLastNameLike( "01/01/2010", "jo%");
 
Super easy, right?  Download the bleeding edge now to play with them!  (https://github.com/ColdBox/coldbox-platform/zipball/development)
 
Here's a quick demo from today's ColdBox Connection meeting: http://experts.adobeconnect.com/p6byoxrm7aa/
 
P.S. You can still have control over things such as your query's maxResults and offset by passing a struct of settings in as the last parameter to your dynamic method.
 

 

Add Your Comment

Recent Entries

"102 Tips and Tricks for ColdBox HMVC Applications" out on Amazon

"102 Tips and Tricks for ColdBox HMVC Applications." is now available as an e-book, hardcover, and paperback formats. Whether you're a seasoned ColdFusion developer or just starting your journey, this book is a must-have addition to your library to become a master in CFML with modern tools.****

Maria Jose Herrera
Maria Jose Herrera
September 21, 2023
CFCast Series: Mastering CBWIRE 3

CFCast Series: Mastering CBWIRE 3

CBWIRE, a ColdBox module, enables you to quickly develop modern, responsive CFML applications without relying heavily on JavaScript or creating backend APIs. With CBWIRE, you can become a web development hero!

We have just published the first video of our series, more coming soon!

Maria Jose Herrera
Maria Jose Herrera
September 20, 2023