Populate List from Using Data Cache without population Columns

[NormanRMouton]

The Client-side Data Cache new functionality (genie) is very good. In the video Selwyn demonstrates how to populate a list and dynamically sets the columns. What function do I use if I only wants to populate the list in the on-success event and do not set the columns dynamically?

[kenshap]

Re: Populate List from Using Data Cache without population Columns

I do this exact thing. The data returned is json you should be able to populate the list easily. I won't be at the computer until tomorrow ill upload some sample code if no one else answers.

[NormanRMouton]

Re: Populate List from Using Data Cache without population Columns

Ken. I will wait for your sample code. Thank you

[kenshap]

Re: Populate List from Using Data Cache without population Columns

Norman, sorry I'm late with this, I had a bit of a busy couple of days.

Ok, you have to create an action javascript for the client side data cache actions. The action name is read data and you fill in your data item. (which I'm sure you know, I'm just starting from the basics)

Here are two samples both of which go in the onsuccess javascript event.

---this first sample is to populate a drop down. The tags description and locationid must much the case from your sql query.

var arr = [];
var b = [];
for(var i = 0; i < data.length; i++) {
b=[];
b.push(data[i].description);
b.push(data[i].locationid);
arr.push(b);
}
{dialog.Object}.populateDropdownBox('LOCATIONID',arr,true);


-- this next sample is to populate a list box

-- this first line is an example of a filter to be applied
data.clientid == {dialog.Object}.getValue('clientid') && data.actionid == {dialog.Object}.getValue('actionid')


-- this is the code that goes in the onsuccess event. Note my assumption is the list matches the data items in the client side cache, item for item. If they do not, there are tutorials in the pre-release notes that provide samples. Since the items match, my list is populated with the existing formatting, css, etc.

var _lobj = {dialog.object}.getControl('LIST4');
_lobj.populate(data);


That is all there is to it. Figuring it out is another story.

Regards, Ken

[NormanRMouton]

Re: Populate List from Using Data Cache without population Columns

Ken
Thank you very much. I used:
var _lobj = {dialog.object}.getControl('LIST4');
_lobj.populate(data);

And works on my developing computer in Live Preview and Working Preview perfectly.
I wrap it in phonegap and installed it on my IPhone 4S. Then it does not read the data from the file system / local storage.
Can you perhaps help?

[kenshap]

Re: Populate List from Using Data Cache without population Columns

Hi Norman,

In the latest prerelease Selwyn has a video about client side data cache; its definitely useful. Let me know if you need a link.

[peteconway]

Re: Populate List from Using Data Cache without population Columns

You need this build

3411 (THIS IS A BETA RELEASE OF Alpha Anywhere)
Addins: 4611

or greater to use the cache with PhoneGap - Selwyn has done some great work on this.