JSDO join tables

Posted by sebastian.lucaciu on 07-Aug-2017 10:15

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?

Posted by egarcia on 08-Aug-2017 09:25

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

Posted by egarcia on 08-Aug-2017 09:25

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.

This thread is closed