M&M
Posts: 0
Joined: Tue Nov 11, 2014 6:59 am

Way to display lots of database data

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

M&M
Posts: 0
Joined: Tue Nov 11, 2014 6:59 am

Way to display lots of database data

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."
}
]

Simon Hutchinson
Posts: 0
Joined: Thu Jun 13, 2013 11:18 am

Way to display lots of database data

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

Simon Hutchinson
Posts: 0
Joined: Thu Jun 13, 2013 11:18 am

Way to display lots of database data

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.

Simon Hutchinson
Posts: 0
Joined: Thu Jun 13, 2013 11:18 am

Way to display lots of database data

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

M&M
Posts: 0
Joined: Tue Nov 11, 2014 6:59 am

Way to display lots of database data

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

Simon Hutchinson
Posts: 0
Joined: Thu Jun 13, 2013 11:18 am

Way to display lots of database data

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

Simon Hutchinson
Posts: 0
Joined: Thu Jun 13, 2013 11:18 am

Way to display lots of database data

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

M&M
Posts: 0
Joined: Tue Nov 11, 2014 6:59 am

Way to display lots of database data

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

Image

Simon Hutchinson
Posts: 0
Joined: Thu Jun 13, 2013 11:18 am

Way to display lots of database data

no data appears when i do that

Return to “Issues”