Properties
objects) from the repository or repositories specified for the this instance. The following property settings can affect this method:
ObjectStore.DefaultQueryTimeLimit ObjectStore.MaxQueryTimeLimit IServerCacheConfiguration.QueryPageMaxSize IServerCacheConfiguration.QueryPageDefaultSize IServerCacheConfiguration.NonPagedQueryMaxSize
Namespace: FileNet.Api.Query
Assembly: FileNet.Api (in filenet.api.dll)
Syntax
Visual Basic (Declaration) |
---|
Public Function FetchRows( _ ByVal searchSQL As SearchSQL, _ ByVal pageSize As Nullable(Of Integer), _ ByVal filter As PropertyFilter, _ ByVal continuable As Nullable(Of Boolean) _ ) As IRepositoryRowSet |
C# |
---|
public IRepositoryRowSet FetchRows( SearchSQL searchSQL, Nullable<int> pageSize, PropertyFilter filter, Nullable<bool> continuable ) |
C++ |
---|
public: IRepositoryRowSet FetchRows( SearchSQL searchSQL, Nullable<int> pageSize, PropertyFilter filter, Nullable<bool> continuable ) sealed |
J# |
---|
public IRepositoryRowSet FetchRows( SearchSQL searchSQL, Nullable<int> pageSize, PropertyFilter filter, Nullable<bool> continuable ) |
JScript |
---|
public
function FetchRows( searchSQL : SearchSQL, pageSize : Nullable<int>, filter : PropertyFilter, continuable : Nullable<bool> ) : IRepositoryRowSet |
Parameters
- searchSQL
- A
instance containing the SQL statement to use for the search.SearchSQL
- pageSize
- An
indicating the maximum number ofInteger
objects per page to retrieve. This can beProperties
. When unspecified, the default page size (Null
)is used.ServerCacheCofiguration.QueryPageDefaultSize Note: If the
parameter is false orcontinuable
, thisNull
value is ignored.pageSize The number you specify here determines what constitutes a page of query result data. This value, in conjunction with the (
) value you specify for the continuable parameter, can impact retrieval performance.Boolean
- filter
- A
object that represents information for controlling which property values (and with what level of detail and recursion) to return. IfPropertyFilter
, this method returns values for all non-object properties and returns placeholders for all object-valued properties (null
properties with a state ofPropertyEngineObject
orPropertyState.UNEVALUATED
); any subsequent attempts to access an object-valued property will cause an automatic round-trip to the server to fetch its value.PropertyState.REFERENCE
- continuable
- A
value. If false orBoolean
, the query is not paged, theNull
parameter and the default page size inpageSize
are ignored, and the query will return a number of rows limited by the following values:ServerCacheCofiguration.QueryPageDefaultSize - The "TOP" value (if specified) in the selection list.
- The value of
.ServerCacheCofiguration.NonPagedQueryMaxSize
If this
value is true, the query can be continued. In this case, when the end of the first page is reached, a request for the next page ofcontinuable
objects is issued. Page requests iterate until all of theProperties
objects satisfying the query are retrieved.Properties Queries using continuation use
in their implementation. If anORDER BY
clause is not specified in the SQL statement (theORDER BY
parameter), ansearchSQL
clause is used. If anORDER BY Id
clause is specified in the SQL statement, but does not contain theORDER BY
property, theId
property (having a unique value) is appended to the end of theId
clause. You should consider whether the overhead of adding theORDER BY
property to theId
clause is significant for your application. Do not use a continuable query if it would cause a severe performance reduction.ORDER BY
Return Value
An
collection object containing
values.
When the properties are retrieved from multiple repositories, the returned properties can be different than these same properties returned by other methods. This is because the same properties can exist on multiple repositories, yet have different values on each. When such properties are returned by a query across repositories, the property values are aggregated.