Working with retrieved data

Create multiplatform apps with DecSoft App Builder, including Android and iOS with the same base of code.

Design for small screen devices but deploy also (without changes) in larger devices like tablets.

DecSoft HTML Compiler is easy to use: set your project's options and compile your apps and games in a nutshell.

Save money by purchasing our NeoPlugins bundles. Five, Ten and even the complete NeoPlugins collection at an incredible price!

DecSoft NeoPlugins put your VisualNeo projects into another level with +1,000 new actions for your apps.

Create apps and expand their capabilities by using the world's popular programming language: Javascript.

Take a look at some frequently asked questions about us and our products!

DecSoft App Builder include a convenient Command Line Compiler, so you can compile your apps from the console.

DecSoft App Builder integrates an Open AI assistant in order to assist you while developing your apps.

Create modern HTML apps and games at another level making things impossible to do even by modern HTML apps and games.

DecSoft NeoPlugins are available in both runtime and designtime flavours to keep your apps as small as possible.

Apache Cordova's official plugins are supported out of the box and there are hundreds of plugins ready to use.

Take a look at our YouTube channel and subscribe to be notified about new videos!

DecSoft HTML Compiler include a convenient Command Line Compiler, so you can compile your apps from the console.

Compile, convert your modern HTML apps and games into Microsoft Windows executable programs without dependencies.

Save time, resources and money creating apps for Android, iOS and more with the same base of code.

Peter Bradstreet

Hi David, I am trying to get a handle on dealing with retrieved PouchDB data but I am stumbling around in the dark and I was wondering if you could give me a hand to better understand how to approach this. For other data, I am able to retrieve a list of records in a grid and then have the user select an item to update it. In this scenario, though, I just want to retrieve a single record representing the particular users profile data and allow them to edit it. I have the following code which is successfully pulling in a single record which is the user's profile record:

GetOption "dockitusertoken" "usertoken"
SetVar "usertokenvar" "[usertoken]" "String"
StartJS
var utoken = window.App.Scope.usertokenvar
var opts = {live: true, retry: true};
    window.App.RootScope.PouchDB3.replicate.to(CouchDB3, opts);
    window.App.RootScope.PouchDB3.replicate.from(CouchDB3, opts);
window.App.RootScope.PouchDB3.createIndex({
  index: {fields: ['usertoken']}
}).then(
    function () {
      return window.App.RootScope.PouchDB3.find({limit: 1,selector: {usertoken: {$eq: (utoken)}
}, sort: [{'_id': 'desc'}]
});
    })
   .then(
    function(doc, error) {
      window.App.RootScope.Report1.Data = doc.docs;
      window.App.RootScope.fname.Value = "?????";
 window.App.Scope.$apply();
     
    }
  );


EndJS

You can see in this screenshot that I am populating the Report1 field with the retrieved data using doc.docs, this is just for troubleshooting purposes. What I would like to do is to populate the top three fields with the individual information directly from the retrieved data so that I can allow the user to update it but I am unclear as to exactly what doc.docs does and how to refer to specific data within that array?

DecSoft

Hello Peter,

If I understand well, what you need is to deal with the first item of the "docs.doc" array, or, after set it to the Report, deal with the first item of the Report.Data array. An array variable store their items starting by zero, so the "zero" is the first (and maybe in this case the unique) field of the array. So we can code something like this:


window.App.RootScope.fname.Value = doc.docs[0].FIRST_NAME;

And the same for the other fields. Note that "doc.docs[0]" represent the first item in the array. I am not sure if the key is "FIRST_NAME": you must use the expected key(s), of course.

Purchase one or more licenses of our products if they are useful to you!

Peter Bradstreet

Thanks David, I hadn't really thought to utilize the Report field, it was only there for testing purposes but your approach does work and I guess that there is no harm in moving the field off of the view and hiding it. Thanks for your help! Pete

Everybody can read the DecSoft support forum for learning purposes, however only DecSoft customers can post new threads. Purchase one or more licenses of some DecSoft products in order to give this and other benefits.