Cancel all pending queries?

BWCWeb · December 9, 2022, 2:14pm

I have a page that runs through a query that displays quite a bit of results. The issue i have is that i cannot do any work on the page until all queries have completed.

Is there a way to have a query priority if i click on a link?

Here is some screenshots to show you what i am working with

You can see that on this page i have quite a few queries pending to run through

Once i click on a link, the query that this one runs is all the way at the bottom so i have to wait until all previous queries are finished before it will run this one.

Is there any recommendations on how to complete this? I tried to use the Abort on the server connect when the button is clicked, but that doesn’t work.

kryo91 · December 9, 2022, 2:40pm

check no autoload in your server connect, then when you click on a button you only search for the information you want

BWCWeb · December 9, 2022, 2:44pm

right but the query is running to collect the data, which i want.

But i want it when i click on the View button, to put that query at the top to run. I guess something more like a priority list. The other queries can continue in the background as long as i am able to get the information that i need when i click the button.

Eventually they all do need to run to completion, but i just don’t want to wait 3 to 4 minutes for all records to populate before i can do some work on the page.

sitestreet · December 9, 2022, 2:46pm

Why don’t you do a paged query instead and then limit the records returned? That would make it near-instant.

BWCWeb · December 9, 2022, 2:49pm

hmmm, that is a great idea that i haven’t thought of!!!

kryo91 · December 9, 2022, 2:49pm

the requests must be launched I suppose in order that they appear in your file, going up your connected server as much as possible this could perhaps correct this problem

BWCWeb · December 9, 2022, 3:08pm

any workarounds on a paged query where i can implement a custom query? I am currently running my query with a Group by feature that you just cant do with a Paged Query

‘SELECT *
FROM twilio_chat
WHERE realtor_ID = :P1 /* {{$_SESSION.realtor_ID}} */ AND new_message = :P2
GROUP BY from_phone, new_message DESC ORDER BY date_in DESC’

sitestreet · December 9, 2022, 3:51pm

Yes, you need to add LIMIT to the query and set it to use the query vars of LIMIT and OFFSET just like the Paged Query does.

LIMIT :P2 OFFSET :P3

You can then send these value to it using GET variables.

BWCWeb · December 9, 2022, 8:57pm

Okay, i am still working on getting this sorted, but i am running into a wall.

What i have done is setup a Paged Query for my results

I am then running a GroupBy setting and trying to run my repeat setting on those results, but unfortunately when i try to determine my Output fields, it doesn’t show the actual data.

The query seems to be returning the correct results, but i am just not able to get the data to display correctly in the repeat.

Pic of Query Setup

Pic of results

you can see the repeat seems to be repeating the correct amount of times, its just that there is no output data there from what i am setting.

Am i missing something?

BWCWeb · December 10, 2022, 5:12pm

adding this to the query still does not allow the Pagination generator to work with a custom query. I have tried multiple attempts at this.

I am trying to use the Paged Query, with a grouping option, but that also doesn’t seem to work with a query as i cannot get the results from the grouping to display.