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 6175 posts 24186 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
Please Sign in or register to post replies

Write your reply to:

Draft