retrieve a list- from the datasource

Hi Shira,

I assume you are asking about Kendo data source. You can  apply a sorting (asc) on Datasource by Date field thus results your data to ascending order. I put a small code to achieve

var dataSource = new kendo.data.DataSource({

 data: [

   { name: "Xyz", age: 33 , dob:'04/04/1990'},

   { name: "Jane Doe", age: 30 , dob:'04/27/1988' },

 ],

 sort: { field: "dob", dir: "asc" }, //Apply sorting by dob field

 schema:{

   model:{

fields:{

 dob:{type:'date'}, //Make sure you define a build with correct data type

 name:{type:'string'},

 age:{type:'number'}

}

}

 }

});

dataSource.fetch(function(){

 var data = dataSource.view(); //Get sorted order

 console.log(data[0].dob); // displays "27/04/1988"

 var actualData = dataSource.data(); //Get inserted order

 console.log(actualData[0].dob); // displays "04/04/1990"

});

Kindly refer this url for more details 

docs.telerik.com/.../datasource

Hope this helps,

Thanks,

Vimal.

Hi,

You can apply a sort on your dataSource as well in same way how i demonstrated in example. You don't require to create another instance of DataSource . You can call sort method on your dataSource instance, say for an example

dataSource.sort({ field: "dob", dir: "asc" });

Make sure your dataSource instance is having proper schema,model defined. Or if you want to create new Data Source instance by using another dataSource

do like this

var newDataSource = new kendo.data.DataSource({

  data:dataSource.data(), // get data from your own dataSource Instance

  schema:{

      model:{

           fields:{

            }

      }

  }

})

If you need more details kindly create Rollbase App by explaining your requirement , that way we can help you faster.

Thanks,

Vimal.

Hi Shira,

It should be straight forward, you should get data from both DataSources and merge them and use that in your new Data Source.  I assume all 3 Datasources schema model will be same

var data1 = dataSource1.data(); //First data source data

var data2 = dataSource2.data(); //Second data source data

//concat two array data by converting kendo model to actual json

var mergedData = data1.toJSON().concat(data2.toJSON());

var newDataSource = new kendo.data.DataSource({

 data:mergedData,

 sort:{field:'dob',dir:'asc'},

 schema:{

   model:{

fields:{

 dob:{type:'date'},

 name:{type:'string'},

 age:{type:'number'}

}

}

 }

});

newDataSource.fetch(function(){

 var data = newDataSource.view();

 console.log(data[0].dob);

});

Hope this helps,

Thanks,

Vimal.

Hi Shira,

Do you have data in your first and second Datasources?. Could you try to print data1 and data2 in console and see if that has data or empty array?.

May i know how you are creating your first and second DataSources?.  If you are creating from local or json Data you should call dataSource.fetch() method to load your json data into datasources instance.

Thanks,

Vimal.

Hi Shira,

I am sorry it's too much code to understand entire stuff with out actual data, but found few things which may be causing issue for you

First thing I noticed is your Datasource Schema mode seems to be incorrect, it should be like this.

dataSourceOptions = {
type: 'jsdo',
transport: {},
schema: {
model: {
fields: {
'dueDate': {
type: 'date',
defaultValue: ''
},
}
}
},
serverFiltering: true,
serverSorting: true,
serverPaging: true,
pageSize: 50
}

Second issue i can sense is, you are populating your DataSources on call back of loadCatalogs() promise, so ideally you can move merging Datasources to separate method and call that method only when both first and second datasources are populated.
Say for an example something below

function mergeDataSources(dataSource1,dataSource2){
dataSource1.fetch(function (){
var data1 = dataSource1.data();
dataSource2.fetch(function(){
var data2 = dataSource2.data();
var mergedData = data1.toJSON().concat(data2.toJSON());
var newDataSource = new kendo.data.DataSource({
data: mergedData,
sort: { field: 'dueDate', dir: 'asc' },
schema: {
model: {
fields: {
dueDate: { type: 'date' },

}
}
}
});
newDataSource.fetch(function () {
var rec = newDataSource.view();
alert(rec[0].dueDate)
});
})
});
}

Hope this helps,

Thanks,

Vimal

Hi Shira,

It's hard to figure out what goes wrong by looking at such a large code unless I see them with actual data and flow of execution. Could you please raise a support ticket and schedule a call tomorrow  with the help of our support engineer?. I can debug on your machine and try to fix what's goes wrong. From your sample code I can understand you are working on Telerik platform using JSDO  data, but javascript code is not even formatted so unable to figure out actual issue.

Thanks,

Vimal.

Hi Shira,

I am glad it worked for you. Please let us know if you need further assistance on this.

Thanks,

Vimal.