have the group by working great but now when I try ti increase the return of data to include all countries it flakes out, as in displays nothing.
have tried to remove the limit tag from
/dmxDatabaseSources/city-list.php?country={{$FORM.country}}&limit=18000

and also increased to 18000 as above, which is where it flakes.......

Hello Jamie,
Can you please explain what is the number of records you would like to display into the select field?

I have 130k hotels with country and cities, have two drop menus with country and then city. when i group by on the country its grouping the countries but stops at china and then am missing the other 100 odd countries....
I have set it as a limit of 18000 as a test and am returned blank, reducing the limit to say 1000 and I have china.... with a list of about 30 countries displayed.
Of course am needing all countries displayed from the 130k hotels after group by

In the database connection settings add a limit of some big number- 200000 for example, then on results per page you can add 200000 also. Please provide a link where we can check the returned results.

when I set a big number it goes blank, so nothing is displayed, when I change down to 10000 I have china again
Is there a time out on the script that I can change? could that be the problem?

To see it.... hmm think we had this one before, I have a bad habit of not uploading things till they are working lol will need a day or two to finalize the site in general and then I can do that.

Hi Jamie,

Having huge amount of data in the same data source and applying group by is a bad idea.

As your data is hierarchical. you should split it in different data sources that are dependent of each other.

Like having first the countries, then with the selected county you can go and fetch the cities, and then for each city you can fetch all the hotels in it.

You can do this easy by building the different data sources and having filters in them and then just use dependable dropdowns as UI.

Greetings,
George