Alpha Video Training
Results 1 to 4 of 4

Thread: Disconnected Applications Clearing List Data After Sync

  1. #1
    Member
    Real Name
    shahzad rashid
    Join Date
    Nov 2015
    Posts
    36

    Default Disconnected Applications Clearing List Data After Sync

    Hi,

    I am developing a Disconnected Application and wondering if there is a way to clear the data from the Mobile device/Cache after it has been synched with the server. The data I collect on mobile app have master-child records so it would be really helpful if there is a pre-defined function available. I understand that data is stored in browser cache which have 5MB limit so I am concerned that at some point this limit will be used up. Another reason is to have a shorter list of records on device for better UX. If it keeps building up, there will be thousand of records search/view for editing.

    Many thanks for your help.

    Shaz

  2. #2
    Member jgrannis's Avatar
    Real Name
    Jeff Grannis
    Join Date
    Apr 2016
    Location
    New Iberia, LA
    Posts
    339

    Default Re: Disconnected Applications Clearing List Data After Sync

    Have you looked into persisting the list data to the File System instead of Local Storage? You'll only have the 5MB or so limit problem with using Local Storage. You will not have the limitation when persisting to File System.

    Also, not sure that I understand correctly, but if you don't want so much data in your list, you'll have to add a "SQL Data Source Filter" to your query configuration. Then when you refresh from the server, you will only get whatever limited rows that you want on the mobile. I mean, synching is synching. If you have a bunch of data in the database table, you will synch it (refresh it) to the list unless you add some kind of filter in the data source configuration.

  3. #3
    Member
    Real Name
    Daniel Binns
    Join Date
    Apr 2017
    Posts
    41

    Default Re: Disconnected Applications Clearing List Data After Sync

    No idea if this is the best way but what I've been doing to clear list data that isn't needed after a sync is setting the sql query to be WHERE primarykey = ''

    Since after sync the record has a pkey it won't show up in the list. Just do an incremental refresh after sync and it will clear all client side list data.

    '

  4. #4
    Member
    Real Name
    shahzad rashid
    Join Date
    Nov 2015
    Posts
    36

    Default Re: Disconnected Applications Clearing List Data After Sync

    I've implemented a PrimaryKey filter in my query and it working great!

    I'll also look into File System storage.

    Thank you very much for your help!

Similar Threads

  1. new list controls(how to sync data back into db)
    By amitloh in forum Application Server Version 11 - Web/Browser Applications
    Replies: 2
    Last Post: 09-27-2017, 02:59 AM
  2. Disconnected List Control / Detail View - List remains dirty after sync
    By frankiez in forum Mobile & Browser Applications
    Replies: 5
    Last Post: 06-28-2017, 05:03 AM
  3. Sync lists one way only in disconnected app
    By Peter.Greulich in forum Mobile & Browser Applications
    Replies: 17
    Last Post: 05-26-2017, 06:25 PM
  4. List with detail view and disconnected data... help
    By frankbicknell in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 10-16-2014, 03:41 PM
  5. Keeping data in sync from two applications
    By Rayr in forum Alpha Five Version 7
    Replies: 14
    Last Post: 12-02-2005, 11:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •