Query with Random results

Wappler General How To
#1

Is there a way to query data and return and selected amount of results randomly on server side?

So I query a table with 100 locations and I return 5 random locations?

#2

You can either:

  1. On serverside add a query, add a repeat step and for repeat expression select query>format>randomize>top 5. Then on the clientside create a repeat region out of the repeat step (not from the query)

  2. On clientside apply randomize>top 5 filters to the query.

4 Likes
#3

I still can’t figure this out? If I set a repeat on my server side query, I can see how to randomize that. but what do I put in repeat section of the action script?

random
random481×521 20.8 KB

#4

Personally I find it much easier to do on the client side using the App Connect Panel.

1 Like
#5

I can’t find any randomize there?

it should be on the repeat right?

#6

Yes, select your repeat. When you select your serverconnect recordset then click on the formatter icon.

Screen Shot 2020-02-07 at 2.52.05 PM
Screen Shot 2020-02-07 at 2.52.05 PM938×1266 107 KB

1 Like
#7

Yours shows as array, mine is just record set?

snip1
snip1480×755 35.2 KB

#8

Click on the formatter icon … the magic wand

#9

yes brad I know that much. LOL. its just that randomize isn’t there.

#10

I’m repeating a column. maybe i need to repeat a div or something and put the column inside that?

#11

What do you see there? When you click on the formatter?

#12

snip2
snip2496×952 60.3 KB

#13

Hmmmm, interesting. And you are applying it to an element that has a repeat region?

#14

yes

#15 
<div class="row" id="id_featuredProducts">
		<div class="col rounded rounded-sm">
			<div class="row">
				
				<div class="mb-3 align-self-center rounded col-xl-3 col-md-5 col-lg-3 h-auto" id="id_featured" dmx-repeat:featuredrepeat="conn_featuredProds.data.query1.data">
					<a dmx-bind:href="'product-detail.asp?product_id='+product_id"><img dmx-bind:src="/assets/images/{{product_id}}/{{mainphoto}}" class="img-fluid rounded"></a>
					<p class="text-center bg-light mt-2 pt-2 pb-2 pl-2 pr-2 h-auto"><b>{{short_description}}</b><br>{{sku}}<br><%If Session("HitekSecurityId") Then %>{{price.toNumber().formatCurrency("$", ".", ",", "2")}}<% else %> [ <a
							href="my-account.asp">LOGIN TO SEE PRICE</a> ]<% end if %></p>
				</div>
			</div>
		</div>
	</div>
#16

Interesting, in your value properties where it says Type --> text, try choosing Array

#17

weird I got it to work. I just created a regular repeat and added randomize to that. which added .randomize(), I just copied and pasted that to the end of my existing repeat and that did the trick.

1 Like
#18

I know this is quite an old thread, but I was looking for different ideas about returning random results. I decided to follow @Teodor’s suggestion (getting the random results server-side), to avoid returning results I didn’t need. @baub raised a good question in relation to this approach:

It seems you need to include some step in the repeat, but it can simply be a comment (even a disabled one).

It’s not possible to save an API with a repeat unless there’s at least one step in the repeat (albeit a redundant one). Perhaps it should be possible. It’s hardly worthy of a feature request - just a thought.

#19

You can simply put this in a setvalue step, without a repeat on the server side:

Screenshot 2021-04-13 at 11.48.02

2 Likes
#20

Thanks - even simpler.