Using owner Id to store data in account

[mark-piller]

You have logic that saves the current number in the database.

When the user revisits the page, you want to get the number they left off from the previous visit to the page.

To do that, you need to retrieve the number saved in the database when the user opens the page

That is done by making a query to the database and getting the number from the user’s record.

Once you have that number, you initialize a page data properly with it .

[Tyler_Scott]

Ok Yes, I knew that. The problem is that I have tried to do that before and couldn’t find the block to that.

[mark-piller]

@Tyler_Scott

couldn’t find the block to that

A block to do what specifically?

[Tyler_Scott]

@mark-piller

That is done by making a query to the database and getting the number from the user’s record.

This

[mark-piller]

The following tutorials should help:

Basic Data Retrieval API | Backendless Database Training Course (pt. 16)

Requesting Specific Properties | Backendless Database Training Course (pt. 18)

[Tyler_Scott]

Ok heres what I’ve got:

This is in the buttons code

And this is On page Enter:

The problem is, when I run it, it gives me the output “Null”

[Dima (Dima Vak)]

Did you login?
Can you enable “reload” checkbox and retry?
What object you are updating? Did you debug(print values) or check in database if needed user were updated?

[mark-piller]

You’re making good progress, but there are a few problems with the logic you shared:

The following logic will save an incremented value, however the value in Page Data will remain the same - you need to add additional logic to increment the value stored in Page Data

In the following logic you will fetch 10 records from the Users table and store them all in the Points property in Page Data. This is not what you want… You need to retrieve a specific record from Users - the record that corresponds to the currently logged in user. Keep in mind that the Load Table objects block always returns a collection of objects (even if it is a collection of one). So you need to fetch one specific record/object add logic to extract that object from the collection. Then you need to get the Points property from that specific object:

[Tyler_Scott]

Hmm…
I thought I fixed it it but it just wont even show a message now…

Please let me know my mistakes,

Tyler

[mark-piller]

I do not see any changes here:

Regarding the logic above, I described what should be done here:

@mark-piller

You need to retrieve a specific record from Users - the record that corresponds to the currently logged in user. Keep in mind that the Load Table objects block always returns a collection of objects (even if it is a collection of one). So you need to fetch one specific record/object add logic to extract that object from the collection. Then you need to get the Points property from that specific object:

This does not make sense:

The following comment was not addressed in your logic:

@mark-piller

the value in Page Data will remain the same - you need to add additional logic to increment the value stored in Page Data

[Tyler_Scott]

@mark-piller

You need to retrieve a specific record from Users - the record that corresponds to the currently logged in user. Keep in mind that the Load Table objects block always returns a collection of objects (even if it is a collection of one). So you need to fetch one specific record/object add logic to extract that object from the collection. Then you need to get the Points property from that specific object:

So does that mean I can’t use the Load table object block?

Also I don’t get what block I should use for this

@mark-piller

@mark-piller

the value in Page Data will remain the same - you need to add additional logic to increment the value stored in Page Data

[mark-piller]

@Tyler_Scott

So does that mean I can’t use the Load table object block?

No, you need to use that block, but you need to enhance the logic so it also does the following:

1. Uses a where clause to load a record for the current user
2. Extract the first object from the value returned by Load Table object
3. Extract the Points value from the object returned by #2 in this list.

Regarding the following, I believe this should help: https://youtu.be/3mN4BTHt2WQ?si=Xswx6JkHbJ0-zMU5

@Tyler_Scott

Also I don’t get what block I should use for this

@mark-piller

@mark-piller

the value in Page Data will remain the same - you need to add additional logic to increment the value stored in Page Data

[Tomdabom]

Hi Mark,

I hope you’re doing well!

I wanted to reach out as part of the Pocket Perks development team regarding the page size settings for retrieving items from the “Users” table. It seems that when I set the page size to 10, it returns only 11 items, and I’d like to retrieve all entries. Here is the block:

Your help has been greatly appreciated, and I’m confident we’re on to something.

Best regards,
Tom
Pocket Perks Development Team

[mark-piller]

Hi Tom,

When you set it to 10, it should return up to 10. The maximum value supported in the Cloud version is 100; you can use paging to retrieve more. Here’s a doc on paging:

https://backendless.com/docs/js/data_data_paging.html

Regards,
Mark

[mark-piller]

@Tomdabom , also, please create a new topic for every new question. It will help keep the conversations on topic, and others can benefit from finding answers faster.

Thank you!

[Tomdabom]

Hi Mark,

Thanks for the clarification! I appreciate the link to the documentation on paging. I’ll take a closer look at that to better understand how to retrieve all the items I need.

If I have any further questions, I’ll be sure to create a new topic as suggested.

Thanks again for your help!

Best,
Tom

[mark-piller]

You are welcome!

Btw, here’s a how-to article describing how to use paging to load more than 100 objects:

How to set pageSIze > 100 in the "Load Table Objects" block

Codeless block “Load Table Objects” doesn’t have the ability to load more the 100 objects. To load data with “page size” > 100 you can create custom “loadTableObject” function. It works like the default block. But keep in mind that for every 100 pages there is a separate request. (There will be 5 requests for pageSize = 430) Notice: On the “Managed” or “Pro” plan you can increase page size limit [Codeless - BL - dsdfsd - Backendless 2021-12-01 12-48-31] [Codeless - BL - dsdfsd - Backendl…

[Tomdabom]

Hi Mark,

I just wanted to say a big thank you for your help with updating the User table in Backendless. What we’re doing right now would not have been possible without your expertise and support!

Best regards,
Tom

[mark-piller]

You are most welcome. Glad I was able to provide some guidance.

Regards,
Mark

[Tyler_Scott]

Hi Mark,
I Just wanted to say thank you,
I went on holiday and came back and the sultion jst clicked for me.
As for the real time database part, the app seems to be working fine without it.

Thanks so much,
Tyler