Forum Discussion

JeffKelly1's avatar
JeffKelly1
Qrew Member
6 years ago
Do you know of any way to delete all revisions? I'm hoping to clear up some usage but this method just leaves the attachment in the attachment history.

------------------------------
Jeff Jeff
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Try this thread, for Eric's response and post back when you get it working with your code.  If you get a URL working to delete one revision version, but need help stringing several of them together to delete the other versions, post back and I can help with that.

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=9e640229-f87e-42c1-b243-da04a6381a26&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • JeffKelly1's avatar
    JeffKelly1
    Qrew Member
    6 years ago
    To test deleting the previous version, so far I've tried adding the following parameters to the URL with no luck:
    &_vid_1=
    &_vid_1=0
    &delfile_vid_1=0
    &_vid_1=&delfile_vid_1=1
    &_vid_1=&delfile_vid_1=0

    Also tried these with "_vid_2" just in case it's one-indexed.

    ------------------------------
    Jeff Jeff
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      Yes I see that this is not solved.

      I tried this to try to delete the 1st revision, ie the 2nd one on the list, but it did not work.   So right now I'm stumped too.

      var text DeleteFile = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
      & "&_fid_7="
      & "&delfile_fid_7=1"
      & "&vid=1";


      var text DisplayRecord = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];

      $DeleteFile
      & "&rdr=" & URLEncode($DisplayRecord)

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------