Understand FindAll query definition guidelines.
By default, a FindAll object query is generated for every MBO and uses these values:
- Name – FindAll
- Parameters – none ( A FindAll query without parameters generates a query such as
Select * from ...
)
- Query Definition – SELECT x.* FROM {Entity} x
- Create an index – false
- Return Type – Multiple Objects (accepts {Single Object, Multiple Objects, Result Set})
Unwired WorkSpace validates the query name and disallows it if it is a reserved word or restricted in some way, including:
- All MBO operation names
- Standard generated getter/setter methods (Get{Attribute}/Set{Attribute})
- Standard generated relationships (Get{RelationShip}/Set{RelationShip/Get{RerlationShip}Size}
- Standard methods (find, create, delete, update, save, refresh)
- GetMetaData
- GetClassMetaData
- Anything that starts with a underscore (e.g. _init)
- IsDeleted, IsDirty, and so on
- KeyToString
- Equals
- GetHashCode
- xxxFilterBy(...)
- Bind
- Load
- Find
- Find_os
- Merge
- CopyAll
- CreateBySQL
- GetDownloadState
- Set/GetOriginalState
- CancelPending
- CancelPendingOperations
- SubmitPendingOperations
- Internal_{xxx}
- SubmitPending
- FromJSON/ToJSON{List}
- GetSize
- FindWithQuery
- Subscribe_{xxxx}/Unsubscribe_{xxx}
- GetPendingObjects
- GetSynchronizationParameters
- GetLogRecords
- LastOperation
- GetCallbackHandler