Filtering Issue

• 20 kwietnia 2012 14:55

   

   
  

  0

  In the sample code which is part of syncframework toolkit, filtering is done with userid. This userid is associated with every table partcipating in sync.

  But for our case we are doing sync with respect to our traditional database where userid is not associated with every table participating in sync. This  leads to the following problem:

  We have user table,order table and orderdetails table. user table has userid,order table has userid as foreign key and orderdetails have orderid as foreignkey. so when we do a sync we are just passing userid as filter parameter. it will lead to retrieve only user and order table datas. we wont be getting order details data as there is no user id to filter out orderdetails.

  one solution obviously will be passing orderid as filter parameter. but the drawaback is it wont return all the order details of that user. we need all the order details of that user.

  Any solution to this problem is appreciated.

  Thanks in advance

  Bijo Abraham

  
  

  • Zmodyfikowany przez b_abrams 20 kwietnia 2012 14:56
  •  
  • Odpowiedz
  • Cytuj