Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Chris Bodman 13 posts 93 karma points
    Nov 13, 2018 @ 10:52
    Chris Bodman
    0

    UFRecords, RecordData readable format

    Hi Everyone,

    I've been given the task of getting the information from submitted forms, and turning it into a readable format.

    Naturally I have access to the SQL DB, and I've got to the table, but obviously the data in the RecordData column is XML/JSON, but I can't find the mapping for it. I assume somewhere there's a mapping for these fields. Can anyone point me in the right direction?

    Thanks in advance

    Chris

    Copy Link
  • Alex Skrypnyk 6182 posts 24284 karma points MVP 8x admin c-trib
    Nov 20, 2018 @ 14:20
    Alex Skrypnyk
    0

    Hi Chris

    Do not use SQL for operations like that.

    Example how to get all records for contact form:

    var formStorage = new FormStorage();
var recordStorage = new RecordStorage();
var allRecords = recordStorage.GetAllRecords(formStorage.GetForm("contact"));

    Hope it helps.

    Alex

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies