TableRequestInfoV5
Overview
As well as TableRequestInfo, TableRequestInfoV5 class allows to specify additional custom parameters for getting data from certain schema table.
TableRequestInfoV5 extends TableRequestInfo class with new features Dynamic Where and Dynamic Select supported starting from DA v5.
Below you can find a sample that shows how to create and use TableRequestInfoV5.
Location
- Reference: DataAbstract4_Intf.h
- Namespace: DataAbstract
- Ancestry: NSObject | ROComplexType | TableRequestInfo | TableRequestInfoV5
assignFrom: assignFrom:(ROComplexType *)
Configures instance of the TableRequestInfoV5 class according to given source
- (void) assignFrom:(ROComplexType *)aValue
Parameters:
- aValue:
assignFrom: assignFrom:(nonnull ROComplexType *) (declared in ROComplexType)
- (void) assignFrom:(nonnull ROComplexType *)source
Parameters:
- source:
deepCopyWithZone: deprecated (declared in ROComplexType)
- (nullable id) deepCopyWithZone:(nullable NSZone *)zone
Parameters:
- zone:
DynamicSelectFieldNames nonatomic
Property that holds an array of field names for Dynamic Select feature.
@property (nonatomic) StringArray *DynamicSelectFieldNames
getAttributeValue: (declared in ROComplexType)
+ (nullable NSString *) getAttributeValue:(nonnull NSString *)aName
Parameters:
- aName:
IncludeSchema nonatomic (declared in TableRequestInfo)
Boolean property that specifies if table schema info s needed inside the result stream (true) or not (false, default). Usually, the client side already knows the schema, so passing the schema with the table data will cause some overhead, but if you need to update table schema info on the client side, you need to set that property to true.
@property (nonatomic) BOOL IncludeSchema
MaxRecords nonatomic (declared in TableRequestInfo)
This property allows to limit the count of rows of the request. Put it as -1 to receive all available records. 0 value will update the table schema without receiving any data.
Limiting the amount of transferred rows can reduce traffic between the DataAbstract server (middle tier) and the DataAbstract client (front-end tier). It will not affect traffic between the database and the DataAbstract server. For reducing traffic between the database and the DataAbstract server, you have to use other approaches, like Dynamic Where.
@property (nonatomic) int32 MaxRecords
Parameters nonatomic (declared in TableRequestInfo)
Represents the array of the DataParameters for getting data from parametrized schema tables.
@property (nonatomic) DataParameterArray *Parameters
readFromMessage:withName: readFromMessage:(nonnull ROMessage *) withName:(nullable NSString *) (declared in ROComplexType)
- (void) readFromMessage:(nonnull ROMessage *)aMessage withName:(nullable NSString *)aName
Parameters:
- aMessage:
- aName:
readFromMessage:withName: readFromMessage:(ROMessage *) withName:(NSString *)
Metod deserializes TableRequestInfoV5 with given name from given message
- (void) readFromMessage:(ROMessage *)aMessage withName:(NSString *)aName
Parameters:
- aMessage:
- aName:
Sorting nonatomic
Property represents the information about sorting result data.
@property (nonatomic) ColumnSorting *Sorting
UserFilter nonatomic (declared in TableRequestInfo)
Uses for specifying custom conditions for returning rows. For example, "CustomerType < 100". Note that all records will be read from the database, but only those that fit the custom condition will be passed to the client.
@property (nonatomic) NSString *UserFilter
WhereClause nonatomic
Property that holds Dynamic Where expression in XML format.
@property (nonatomic) ROXml *WhereClause
writeToMessage:withName: writeToMessage:(nonnull ROMessage *) withName:(nullable NSString *) (declared in ROComplexType)
- (void) writeToMessage:(nonnull ROMessage *)aMessage withName:(nullable NSString *)aName
Parameters:
- aMessage:
- aName:
writeToMessage:withName: writeToMessage:(ROMessage *) withName:(NSString *)
Metod serializes TableRequestInfoV5 with given name into given message.
- (void) writeToMessage:(ROMessage *)aMessage withName:(NSString *)aName
Parameters:
- aMessage:
- aName:
DynamicSelectFieldNames nonatomic
Property that holds an array of field names for Dynamic Select feature.
@property (nonatomic) StringArray *DynamicSelectFieldNames
IncludeSchema nonatomic (declared in TableRequestInfo)
Boolean property that specifies if table schema info s needed inside the result stream (true) or not (false, default). Usually, the client side already knows the schema, so passing the schema with the table data will cause some overhead, but if you need to update table schema info on the client side, you need to set that property to true.
@property (nonatomic) BOOL IncludeSchema
MaxRecords nonatomic (declared in TableRequestInfo)
This property allows to limit the count of rows of the request. Put it as -1 to receive all available records. 0 value will update the table schema without receiving any data.
Limiting the amount of transferred rows can reduce traffic between the DataAbstract server (middle tier) and the DataAbstract client (front-end tier). It will not affect traffic between the database and the DataAbstract server. For reducing traffic between the database and the DataAbstract server, you have to use other approaches, like Dynamic Where.
@property (nonatomic) int32 MaxRecords
Parameters nonatomic (declared in TableRequestInfo)
Represents the array of the DataParameters for getting data from parametrized schema tables.
@property (nonatomic) DataParameterArray *Parameters
Sorting nonatomic
Property represents the information about sorting result data.
@property (nonatomic) ColumnSorting *Sorting
UserFilter nonatomic (declared in TableRequestInfo)
Uses for specifying custom conditions for returning rows. For example, "CustomerType < 100". Note that all records will be read from the database, but only those that fit the custom condition will be passed to the client.
@property (nonatomic) NSString *UserFilter
WhereClause nonatomic
Property that holds Dynamic Where expression in XML format.
@property (nonatomic) ROXml *WhereClause
getAttributeValue: (declared in ROComplexType)
+ (nullable NSString *) getAttributeValue:(nonnull NSString *)aName
Parameters:
- aName:
assignFrom: assignFrom:(ROComplexType *)
Configures instance of the TableRequestInfoV5 class according to given source
- (void) assignFrom:(ROComplexType *)aValue
Parameters:
- aValue:
assignFrom: assignFrom:(nonnull ROComplexType *) (declared in ROComplexType)
- (void) assignFrom:(nonnull ROComplexType *)source
Parameters:
- source:
deepCopyWithZone: deprecated (declared in ROComplexType)
- (nullable id) deepCopyWithZone:(nullable NSZone *)zone
Parameters:
- zone:
readFromMessage:withName: readFromMessage:(nonnull ROMessage *) withName:(nullable NSString *) (declared in ROComplexType)
- (void) readFromMessage:(nonnull ROMessage *)aMessage withName:(nullable NSString *)aName
Parameters:
- aMessage:
- aName:
readFromMessage:withName: readFromMessage:(ROMessage *) withName:(NSString *)
Metod deserializes TableRequestInfoV5 with given name from given message
- (void) readFromMessage:(ROMessage *)aMessage withName:(NSString *)aName
Parameters:
- aMessage:
- aName:
writeToMessage:withName: writeToMessage:(nonnull ROMessage *) withName:(nullable NSString *) (declared in ROComplexType)
- (void) writeToMessage:(nonnull ROMessage *)aMessage withName:(nullable NSString *)aName
Parameters:
- aMessage:
- aName:
writeToMessage:withName: writeToMessage:(ROMessage *) withName:(NSString *)
Metod serializes TableRequestInfoV5 with given name into given message.
- (void) writeToMessage:(ROMessage *)aMessage withName:(NSString *)aName
Parameters:
- aMessage:
- aName: