[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Lookup Field returns null from rbf_selectQuery but not from rbf_getRelatedIds

  • Thread starter Thread starter Mohammed Siraj
  • Start date Start date
Status
Not open for further replies.
M

Mohammed Siraj

Guest
For fetching lookup field values for a record, it is advised to use Server-side API getRelatedIds instead of selectQuery. selectQuery implementation is optimized to fetch field values persisted orthogonal & specific to each individual record. However for lookup field values which are basically references to other records in the system, selectQuery results may be inconsistent. That said, for selectQuery API we have done additional corrections in Rollbase 5.1 release to ensure it retrieves the correct set of values for single cardinality lookup fields. That is when fetching single value lookup fields ( 1 side of relationship in 1:1, 1:M , M:1), selectQuery API will also return results consistent with getRelatedIds.

Continue reading...
 
Status
Not open for further replies.
Back
Top