Skip to main content
Solved

Offline mobile select

P
Captain
Forum|alt.badge.img+5

Hi,

I am creating scanner functionality for the mobile GUI which also must be available offline. I have the possibility to insert a new scan

Example of my insert.

1var db = context.application.getStorageContainer();
2var scan = context.application.model.getObj("scan");
3var inserts = [];
4var newRow = {
5      date_time                  : new Date() 
6      ,session_id                : rowObject["session_id"]
7      ,product_id                : rowObject["product_id"]
8      ,scanner_id                : rowObject["scanner_id"]
9      ,slaughter_sequence_no     : rowObject["slaughter_sequence_no"]
10      ,weight                    : rowObject["weight"]
11      ,is_vib                    : rowObject["is_vib"]
12      ,processed                 : 0
13      ,deleted                   : 0
14     };
15
16var insert = (function (insertRow){
17    // add record    
18    return db.insertBookmark(scan, TSFRowBookmark.fromObject(scan, insertRow), true);
19})(newRow);

This works great.

What I now need is the possibility to do a select from the scan table. (a count where session_id = @session_id). How can I achieve that?

Kind regards,

Peter

Best answer by Leroy Witteveen

Hi @Peter Kruis,

Something like this should do the trick:

1var query = new TSFQuery(scan.webserviceId);
2var sessionIdFilter = {
3    session_id: newRow.session_id
4};
5
6query.keyRange = IndexedDb.createPKKeyRangeFromBookmark(scan, TSFPkBookmark.fromObject(scan, sessionIdFilter));
7var deferred = jQuery.Deferred();
8db.executeQuery(query, scan).always(function(reader) {
9    if (reader && reader.length) {
10        var row = reader.item(0);
11        // You have access to the 'row' variable here.
12    }
13});

 

Kind regards,
Leroy Witteveen

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

4 replies

Leroy Witteveen
Moderator
Forum|alt.badge.img+3

Hi @Peter Kruis,

Something like this should do the trick:

1var query = new TSFQuery(scan.webserviceId);
2var sessionIdFilter = {
3    session_id: newRow.session_id
4};
5
6query.keyRange = IndexedDb.createPKKeyRangeFromBookmark(scan, TSFPkBookmark.fromObject(scan, sessionIdFilter));
7var deferred = jQuery.Deferred();
8db.executeQuery(query, scan).always(function(reader) {
9    if (reader && reader.length) {
10        var row = reader.item(0);
11        // You have access to the 'row' variable here.
12    }
13});

 

Kind regards,
Leroy Witteveen

P
1 person likes this
  • P
    Peter Kruis
P
Captain
Forum|alt.badge.img+5
  • Peter KruisCaptain
  • Author
  • Captain
  • 47 replies
  • April 16, 2021

Hi @Leroy Witteveen,

Most of it works great. However, when I set the rowObject value. It is not setted in the GUI when running it. However, when I am debugging it, it fills it. I think I am missing something small.

1var db = context.application.getStorageContainer();
2var scan = context.application.model.getObj("scan");
3
4
5var query = new TSFQuery(scan.webserviceId);
6var sessionIdFilter = {
7    scan_id: rowObject["scan_id"]
8};
9
10query.keyRange = IndexedDb.createPKKeyRangeFromBookmark(scan, TSFPkBookmark.fromObject(scan, sessionIdFilter));
11var deferred = jQuery.Deferred();
12db.executeQuery(query, scan).always(function(reader) {
13    if (reader && reader.length) {
14        var row = reader.item(0);
15        // You have access to the 'row' variable here.
16        rowObject["slaughter_sequence_no_previous"] = row.itemObject.slaughter_sequence_no;
17
18//when debugging, above row is done (or at least the GUI will be filled). When normal running, the //GUI will not contain the slaughter_sequence_no.
19//Using the same scan_id in both examples. 
20
21        deferred.resolve();
22    }
23});
24
25return deferred.promise();

 

Leroy Witteveen
Moderator
Forum|alt.badge.img+3

Hi @Peter Kruis,

You should see “db.executeQuery” as the equivalent to the SQL SELECT statement.
If you want to set “slaughter_sequence_no_previous” to the value of “slaughter_sequence_no”, you need the equivalent of the SQL UPDATE statement, which is db.updateRow.

It can be used like this:

1var db = context.application.getStorageContainer();
2var scan = context.application.model.getObj("scan");
3
4
5var query = new TSFQuery(scan.webserviceId);
6var sessionIdFilter = {
7    scan_id: rowObject["scan_id"]
8};
9
10query.keyRange = IndexedDb.createPKKeyRangeFromBookmark(scan, TSFPkBookmark.fromObject(scan, sessionIdFilter));
11var deferred = jQuery.Deferred();
12db.executeQuery(query, scan).always(function(reader) {
13    if (reader && reader.length) {
14        var row = reader.item(0);
15        row["slaughter_sequence_no_previous"] = row.itemObject.slaughter_sequence_no;
16
17        db.updateRow(scan, TSFPkBookmark.fromObject(scan, sessionIdFilter), row, true).always(function() {
18            deferred.resolve();
19        });        
20    }
21});
22
23return deferred.promise();



 

P
Captain
Forum|alt.badge.img+5
  • Peter KruisCaptain
  • Author
  • Captain
  • 47 replies
  • April 21, 2021

Good morning @Leroy Witteveen,

No, that is not really what I ment. I am executing this function from the default procedure. However, when executing, the fields in the screen (which are in the rowObject) are not changed on the GUI.

When I am debugging, they are. Looks like something is still executing parallel.

I will try to find it later this week.

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings