...
Super Groups
| Mockup |
|---|
| Super Groups |
|---|
| Version | 1 |
|---|
| Name | Super Groups |
|---|
| 1 | 1Super Groups |
|---|
|
Super Heroes
| Mockup |
|---|
| Super Hero |
|---|
| Version | 1 |
|---|
| Name | Super Hero |
|---|
| 1 | 1Super Hero |
|---|
|
Super Powers
| Mockup |
|---|
| SuperPowerFullDisplaySuperPowerFullDisplay |
|---|
| Version | 1 |
|---|
| Name | 1SuperPowerFullDisplay |
|---|
| SuperPowerFullDisplay |
|---|
|
Type Webskins (aka List Views)
...
application.fapi.getContentObjects() massively improves on older methods by:
- using dynamic arguments for filtering
- handling filters on date columns that can have null values
- automatically filtering results by their status
- using
cfqueryparam for all filter values
The arguments are:
- typename (req)
- lProperties (default=objectid)
- status (default=request.mode.lValidStatus)
- orderBy (default=unordered)
- property filters*
Property filters are arguments in the form propertyname_comparison=value. Supported comparisons are:
- eq, neq (equality filters)
- in, notin (list filters)
- like (standard DB like comparison)
- isnull (boolean value to specify whether to return null properties or not)
- gt, gte, lt, lte (standard comparisons, null dates always pass these filters)
| Code Block |
|---|
| title | Examples getContentObjects() in Action |
|---|
|
qLatestNews = application.fapi.getContentObjects(typename="dmNews",lProperties="objectid,title",publishDate_lt=now(),expiryDate_gt=now(),orderBy="publishDate desc")
qLockedHTML = application.fapi.getContentObjects(typename="dmHTML",locked_eq=1)
qNotActiveUsers = application.fapi.getContentObjects(typename="dmUser",userstatus_in="inactive,pending")
|
...