[Dropdown] Delay in remote dropdown content update


#1

I have a dropdown loaded with remote content, through the use of the “apiSettings” option.

When I add a new entry in the database that serves as the API endpoint, it takes some time before appearing in the dropdown (up to 20 minutes), even after a Ctrl+F5 or a cache clear. The entry is added immediately to the db.

Any opinion on that one ?

Thanks


#2

it’s not a dropdown problem,
are you checked sql query for new entry?


#3

Sorry for the delay in replying.

Yes, SQL Query is correct. I have another method in some other place that calls the same query, and there the latest entry shows immediately after creation.

In the dropdown, it sometimes takes up to 20 minutes, and sometimes it is immediate.


#4

in php file with api endpoint add:
header(‘Expires: Sun, 01 Jan 2014 00:00:00 GMT’);
header(‘Cache-Control: no-store, no-cache, must-revalidate’);
header(‘Cache-Control: post-check=0, pre-check=0’, FALSE);
header(‘Pragma: no-cache’);


#5

did you get this sorted? It’s not a problem with SUI. it must be a problem with your code, network or database.


#6

Sorry for not replying. I am also working on another project that took over this one so did not take time to check. I’ll let you know !

Thanks anyway :slight_smile: