Convert Database Query to a Database Paged Query

Feature Request
#10

Thanks George, however I figured that out some time now…lol

1 Like
#11
#12

This has been integrated in Wappler 2.4.5

Now you can change the database query type using a dropdown.

1 Like
#13

This new Wappler 2.4.5 feature of “easily change the Query Type between Multiple Records, Single Record or Paged Records” sounds really interesting to me, but I’m not clear on the difference between each of these three options.

Can someone put it in context for me by replying with quick examples/scenarios of when you’d use each of the three?

Thanks!

#14

The names are pretty much self explanatory :slight_smile:

Database Query
This step allows you to create a database query, which returns all the records which match the conditions.

Database Paged Query
This step allows you to create a database query, which can be limited to show certain number of records per page. The results can be used with paging controls on your page.

Database Single Query
This step allows you to create a database query which returns a single record. That’s really useful in cases where you filter your data and expect a single result to be always returned, like retrieving the logged in user info, or a product detail etc.

1 Like
#15

I’ve updated to 2.4.5 but can’t find that dropdown! Can you give me a clue?

#16

Well, select your query in the server action steps and you will see it in the properties panel :slight_smile:

#17

That’s exactly where I looked expecting it to be there… but it’s not! Can you give me a screenshot?

#18

Screenshot_35
Screenshot_35.jpg480×613 56 KB

1 Like
#19

That’s where I thought it would be but it’s definitely not there for me.

28
Screenshot 2019-12-19 at 16.04.28.png784×538 16.6 KB

11

1 Like
#20

Weird :slight_smile:
Try uninstalling and reinstalling Wappler to see if that will help.

#21

I’m on a Mac. Any risk of losing anything like settings?

#22

I can confirm it is not there on a Mac.

#23

That’s strange.
@George will check this.

1 Like
#24

Mac users can follow this guide to refresh all the extensions:

#25

Ok, just did that but it didn’t help.

56%20AM
Screen Shot 2019-12-19 at 9.30.56 AM.png724×986 66.5 KB

#26

ah sorry guys … forgot to include the update of one file for the mac installation…

Will do it in the next update.

4 Likes
#27

Thanks @George. Will this be in four weeks or are you able to squeeze it out before then just with that fix? :slight_smile:

1 Like
#28
#29