Page 3 of 5

Way to display lots of database data

Posted: Sat Jan 24, 2015 1:17 pm
by M&M

And also have you checked the Responce when you set up the database / Rest service? It does return all the records rite


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:19 pm
by M&M

In my case the Response in the form of JSON goes like this

[
{
"id":"54c383d7e4b0dfbfc129bb2b",
"Name":"John",
"createdAt":"2015-01-24 11:36:55.606",
"updatedAt":"2015-01-24 11:38:14.030",
"Age":25.0,
"Salutation":"Mr."
},
{
"id":"54c383f1e4b0dfbfc129bb2d",
"Name":"Susan",
"createdAt":"2015-01-24 11:37:21.123",
"updatedAt":"2015-01-24 11:38:11.718",
"Age":29.0,
"Salutation":"Ms."
},
{
"id":"54c383fbe4b0dfbfc129bb2e",
"Name":"Jack",
"createdAt":"2015-01-24 11:37:31.771",
"updatedAt":"2015-01-24 11:38:10.587",
"Age":56.0,
"Salutation":"Mr."
},
{
"id":"54c383e5e4b0dfbfc129bb2c",
"Name":"Michael",
"createdAt":"2015-01-24 11:37:09.507",
"updatedAt":"2015-01-24 11:38:12.758",
"Age":33.0,
"Salutation":"Mr."
}
]


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:24 pm
by Simon Hutchinson

Hello yes its all being returned :)

I have managed to make some level of progress but a new problem.

It is now looping in some ways but not correct.

So lets say i have 3 fields i want to loop like what you did in your example

A
B
C

is what you would expect

well mine is going

A
A
A

B
B
B

C
C
C

and the only field looping is A, so its actually

A
A
A
B
C


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:26 pm
by Simon Hutchinson

mapping image

http://snag.gy/enOj8.jpg

Note: i've moved this off to a side page while i am mucking about just so don't have to worry about breaknig other things until i figure this out.


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:27 pm
by Simon Hutchinson

ok i figured out one of the issues, i was not mapping to the right area

however

this issue remains (all are looping now though) :)

A
A
A

B
B
B

C
C
C


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:28 pm
by M&M

I think the most appropriate way to troubleshoot this would be:

Have a brand new blank page :)
Set up the REST Service and see if all the records are being returned. You can test this in the REST/Service set up window
Then add a List Component...and don't map anything except the top most array / looping...

Invoke the service...and see if the List component has the same number of list items that your table / collection has

Once this is confirmed we are pretty close to nailing this problem ",)

Cheers,
M&M


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:30 pm
by Simon Hutchinson

Hey thanks again

Thats exactly what i did! :) and have managed to get further (it is returning the correct amount of items in teh DB Now)

Updated mapping http://snag.gy/kpMyt.jpg

the main issue now is ( and i have no idea what i've done wrong to do that one :( )

a
a
a
b
b
b
c
c
c


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:34 pm
by Simon Hutchinson

i hope this screenshot explains it better, this is the app running after a loop of data

http://snag.gy/6suVL.jpg

As you can see it has looped the data but for example it should be

Jones
West Pennant Hills
1500

next record

Smith
West Pymble
1600

etc


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:34 pm
by M&M

hmmm, can you eliminate all the mapping except for this one

Image


Way to display lots of database data

Posted: Sat Jan 24, 2015 1:38 pm
by Simon Hutchinson

no data appears when i do that