Skip to main content
V
vshanmugavelayu11-Garnet
11-Garnet
February 23, 2017
Question

Mashup - Grid doesnot display all entries in table.

  • February 23, 2017
  • 11 replies
  • 4666 views

I am fetching data from DB using sql script and when i use Grid Widget to display content, the final mashup displays ONLY few of more than 500 rows. how to fix this?

11 replies

S
supandey5-Regular Member
5-Regular Member
February 23, 2017

Hi Varunraj, how many rows are you pulling from the DB?

V
vshanmugavelayu11-GarnetAuthor
11-Garnet
February 23, 2017

Hi Sushant, thanks for the reply!

I have total of around 500 rows. and I could see may be half of it in mashup.

S
supandey5-Regular Member
5-Regular Member
February 23, 2017

Could you share some detail on how you are pulling all the values in the Grid, i am assuming via a SQL Query directly onto the Grid? Are you applying any sort of filter?

Just to confirm when you test the service directly do you get to see more rows than what you see in the Grid Widget?

A
AnnaAn14-Alexandrite
14-Alexandrite
February 23, 2017

Hi Warunraj,

As Sushant noted, you need to check how many rows returned from your DB query? If it's more than 500, you have to manually configure the "Max Rows" in your customized DB query service, and below is the snapshot where to configure it for your refrence.

V
vshanmugavelayu11-GarnetAuthor
11-Garnet
February 23, 2017

Anna, I did try this option and even set it to 1000; however, that did not help. I dont see any change in output.

A
AnnaAn14-Alexandrite
14-Alexandrite
February 24, 2017

Hi Varunraj,

Could you try to create another service, and in the service you call your sql query service which return an result as InfoTable, and then you could call getRowCount() on the result to see how many rows returned, and finally check if it shows the same number of rows in the Grid when running mashup.

Terms & ConditionsAccessibility statement