+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / Paged query problems help.

Paged query problems help.

1 posts, 0 answered
  1. Pierre
    Pierre avatar
    433 posts
    Registered:
    16 Feb 2006
    01 Nov 2010
    Link to this post
    Hi Team,

    I have paged dynamic query returning only page=0 for my requests for a large dataset of items. What is the way to obtain this paged request?.

    public Dataset PagedQuery(int page)
      QueryProduct q1=new QueryProduct();
      q1.ResetConditions();
      
      int PageMax=20;
      q1.Load(20,page*PageMax);//(max items, from)
      
      GroupSerialiser gs=new GroupSerialiser();
      gs.Add(q1);
      
      //Subquery
      QueryProductData q2=new QueryProductData();
      q2.ResetConditions();
      foreach(Product prod in q1)
      {
          q2.OrConditions("ProductID", QueryCondition.EQ, prod.ID)  
      }
      qs.Add(q2);
     
      return ds.Data;
    }

    Demand page = 0 --> OK 2 Tables in dataset
    Demand page = 1 or more --> No Data, No Tables in Dataset, schema is emply.
    if use q1.LoadAll() all items are returned >200 items.
    It's like posted only one time to the server and the response have no data corresponding to the page=1 or more the next time demanded. This issue is the same if you append a  .aspx?Cache=random() to the request to force the server to proceed. Advice please.

    Thanks.
1 posts, 0 answered