http://www.intersoftsolutions.com/Community/Crosslight/How-to-Use-Crosslight-with-All-Related-Data-Available-Offline/http://www.intersoftsolutions.comenCopyright 2002 - 2015 Intersoft Solutions Corp. All rights reserved.60http://www.intersoftsolutions.com/Community/Crosslight/How-to-Use-Crosslight-with-All-Related-Data-Available-Offline/Thu, 25 Jun 2015 03:14:19 GMTArief<p>Hi Jimmy,<br><br>Using our Enterprise Framework, if you want to do partial synchronization, you actually just need to&nbsp;applying the filter in the server side (BeforeExecuteQueryDelegate). <br><br>Here is the documentation: <a href="http://developer.intersoftpt.com/display/crosslight/Synchronizing+Data">http://developer.intersoftpt.com/display/crosslight/Synchronizing+Data</a>. Please see section Adding Custom Filter To Synchronization Query<br><br>Let me know if this solve the partial sycnchronization.<br><br>Best Regards,<br>Arief<br></p> http://www.intersoftsolutions.com/Community/Crosslight/How-to-Use-Crosslight-with-All-Related-Data-Available-Offline/Wed, 24 Jun 2015 20:36:59 GMTjtungol@silentpartnersoft.com<p>Hi,</p> <p>How can we use Crosslight Enterprise Framework to enable offline storage with filtered data? While the app can be semi-disconnected, we need our app to able to download data based on a given criteria, condition and/or range. I'm not sure that was covered anywhere in an article, documentation or sample codes. Well... we don't want to load all data from the database and store it in a local storage, because that would be absurd - considering data can be very huge. Although there will be instances where all data from specific tables should be stored locally, like those that are used as lookup tables (e.g. Caregories).</p> <p>How can this be accommodated by the Enterprise Framework? Say for example, we only need data stored locally based on the user. By that, we mean a set of data (filtered) from a parent table and child tables that are related to the parent. At the same time, also include all data from specific tables that are used as lookup tables (e.g. Categories), useful when creating new records offline. We've done filtering that includes data from related entities with an always online counterpart by using <strong>Includes</strong> in a QueryDescriptor for some ViewModels that require FilterQuery/ViewQuery. But, since synchronization downloads data AppService.OnStart we need to customize its behavior to download or synchronize only the data that we need. Now, how do we do that with Crosslight's data synchronization APIs?<br></p>