Refreshing list data

[[email protected]]

I having a problem refreshing data in a mobile application in drop down list controls
A little background so the problem is easier to understand.

I am a volunteer member of the Sun City Sheriff Posse. I volunteered to help them build some web and mobile applications for dispatching and other functions.
I am using AA to build these applications.
One of the services the Posse offers is Vacation Watch; when homeowners (mostly snowbirds) leave thier homes vacant to extended periods, they can request Posse members regularly visit the site and see if there are any issues.

The vacation watch requests are stored in a table. The visits made to the home sites are stored in a child table.
Every couple of weeks, a site visit schedule is created and routes are assigned. This schedule is stored in another table.

I have built a mobile application that user a list control to view the addresses scheduled to be visited.

Since the schedule contains dates for a two week period and also contains a number of "routes" and "vehicles" that may be assigned to the routes, it is necessary to filter the list for each specific users.

To filter the lists the first panel on the application contains two cascading drop down lists.
The first drop down list shows date contained in the schedule table.
The second list shows valid routes for the date selected in the first drop down.

So the user first selects the date for the route and then list two only shows valid routes for that date.

Once these selections are made, a button is enabled that filters the list control, navigates to the next panel displaying the address for that date and route.

Everything works perfect in development.

Now to the problem.

The application is loaded on the mobile device via phone gap and google play developments site.
Everything works well until new records (every two weeks) are added to the schedule table.
The drop down list do not refresh, they will retain the list of records loaded during the last install.
To overcome this problem, I added a "refresh data" button to the first panel BUT that only refreshes the data in the list.
If the drop down control data does not refresh, the new dates (in the new records) are not available.

So, the questions are (1) why do I have to force the list data to refresh, and (2) how do I get drop down lists to refresh?

[peteconway]

Re: Refreshing list data

You really should look at the SQLite Videos UX_V12-151 & UX_V12-153 as your solution.

[jgrannis]

Re: Refreshing list data

If I understood the problem correctly, it seems to me that you should, in the list control event "afterRefreshData" add some code that in the end will use the populateDropdownBox method.

https://www.alphasoftware.com/docume...x%20Method.xml

The "hardest" part will be building the array to use for the "data" part.

I use this method all the time but almost always start off with an empty, static dropdown (ie. not one configured to be bound to an AlphaDAO data source) That being said, I store all my data on the devices in SQLite databases and am basically forced to use this approach of using the populateDropdownBox method.

EDIT: Just found this which could be a better solution for your case:
https://www.alphasoftware.com/docume...s%20Method.xml

[Davidk]

Re: Refreshing list data

I can't really see how SQLite would help in this situation. This is a refresh data from the server issue.

The title of the post reads "Refreshing list data" but you write about refreshing the data in "drop down list controls", "drop down list", and "drop down control data".

So... some clarification is needed. Are you working with a DropDownBox Control or a TextBox Control configured as an Edit-Combo List?

You also wrote that you added a "refresh button" but didn't state what code that runs.

It doesn't sound as though you are worried about being offline, so a connection to the server is assumed.

If you're using a DropDownBox Control, can you use the .refreshDropdownBoxChoices() method? This method makes an Ajax Callback to the server to get current data... and can operate on multiple DropDownBox controls.

[[email protected]]

Re: Refreshing list data

thank you for taking the time to reply, I will check that out

[[email protected]]

Re: Refreshing list data

I am using a ADO connection that might be part of the problem. I think the "afterRefreshData" event might be a good solution. I will look into the. Thanks for the reply

[[email protected]]

Re: Refreshing list data

There are two "DropDownBox" controls connected to an remote SQL database via DAO connection. I looked for a method to do this before but couldn't find one. I'll look for the refreshDropdownBoxChoices() method. That's for the replay

[jgrannis]

Re: Refreshing list data

List event afterRefreshData + .refreshDropdownBoxChoices() method + keeping your current data source type should work at just fine

[[email protected]]

Re: Refreshing list data

This is the solution I'm hoping will fix the problem. I already had a "refresh" button on the panel so I updated that code to include the .refreshDropDownListChoices function. In testing it worked without blowing up, so I think when I publish it will resolve the problem.

var lObj = {dialog.object}.getControl('VWLIST');
if(lObj) {
if(lObj.listIsDirty()) {
alert('Cannot refresh List because it has unsynchronized edits.');
} else {
var options = {
keepFocusOnCurrentSelection: true,
setFocusToValue: '',
refreshDependentLists: true,
onlyRefreshDependentLists: false
};
{dialog.object}.refreshListData('VWLIST',options);
{dialog.object}.refreshDropdownBoxChoices("RouteDate");
{dialog.object}.refreshDropdownBoxChoices("VechRoute");
}
};

var d = new Date();

{dialog.Object}.setValue("LAST_REFRESH",d);

[Davidk]

Re: Refreshing list data

You're pushing out one too many callbacks. Save them whenever possible. If you're not using any additional options, your code should be...

{dialog.object}.refreshDropdownBoxChoices('RouteDate,VechRoute');