JSDO join tables - Forum - Mobile - Progress Community

JSDO join tables

 Forum

JSDO join tables

This question is answered

Hello,

When using a multi-table (Pro)DataSet, is there an option for joining tables on the client-side using the JSDO?

Also another important aspect would be keeping track of position. Would that be possible?

Verified Answer
  • Hello,

    The JSDO gives has an option to do nested jsdo.<tableref>.foreach() calls to loop through related data (parent/child).

    Calls to jsdo.<tableref>.getData() also honors relations. (The property jsdo.useRelationships determines the behavior.)

    However, there is no general functionality to do joins.

    The JSDO does not have queries with cursors. Depending on your requirements, you could work with the array returned by getData().

    It does provide access to an ID (getId()) which you can use to find the record later via findById().

    Are you using the JSDO directly or with the Kendo UI DataSource?

    Could you provide more info on you use case?

    I hope this helps.

All Replies
  • Hello,

    The JSDO gives has an option to do nested jsdo.<tableref>.foreach() calls to loop through related data (parent/child).

    Calls to jsdo.<tableref>.getData() also honors relations. (The property jsdo.useRelationships determines the behavior.)

    However, there is no general functionality to do joins.

    The JSDO does not have queries with cursors. Depending on your requirements, you could work with the array returned by getData().

    It does provide access to an ID (getId()) which you can use to find the record later via findById().

    Are you using the JSDO directly or with the Kendo UI DataSource?

    Could you provide more info on you use case?

    I hope this helps.