Single records from OE table

2 posts, 0 answers
  1. Tim
    Tim avatar
    8 posts
    Member since:
    Nov 2014

    Posted 13 May 2016 Link to this post

    Hi! Back with another question.

    Is there a way to extract a single record from an OpenEdge database? What I want it to be able to tell the user when they last created an audit with this app. Here is what I have so far, but it is still not liking it. I know that this would not be the complete code to do this, I'm just not sure where to go or if I'm on the right track.

    (function (parent) {
    var dataProvider =;
        dataProvider.loadCatalogs().then(function _catalogsLoaded() {
            var jsdo = new{name: 'Pallet_Audit'});
            jsdo.autoSort = true;
            jsdo.setSortFields( "STAMP_DT:DESC" );

  2. Tsvetina
    Tsvetina avatar
    2139 posts

    Posted 18 May 2016 Link to this post

    Hello Tim,

    You are on the right track - what you are missing is just some code to handle the callback from the database call.

    jsdo.fill().done(function(jsdo, success, request) {
    // get the first item
    if (success) {
    var item = request.response.dsItem.ttItem[0];
    // item.STAMP_DT ...
    }).fail(function() {
    //handle error

    You can read more about handling the fill method callback here:
    fill( ) method

    If you prefer to, you can also use event handlers to process the data returned by the fill method. Both ways are described in the above document.


    Visit the Telerik Verified Plugins Marketplace and get the custom Cordova plugin you need, already tweaked to work seamlessly with AppBuilder.

Back to Top