umbraco 72 plus forms 401 what is new mechanism for retrieving a single record

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

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

Greg 9 posts 29 karma points

Jan 30, 2015 @ 22:38

Umbraco 7.2 + Forms 4.0.1: what is new mechanism for retrieving a single record?

Documentation is light on this topic, and while I have access to recordid in TempData with 4.0.1, I don't see how to retrieve the data for a the submitted form.

Using this to obtain the formId and recordId works.

var formId = "bcc50f76-84eb-4e37-9ab2-dc9401ad6c09";
var recordId = TempData["Forms_Current_Record_id"];

This works to retrieve and review the Record data.

foreach (dynamic record in Library.GetRecordsFromForm(@formId))
{
   <div>Records</div>
    try 
  {
     <div>
           <ul>
                <li>Created:: @record.Created</li>
                <li>Form:: @record.Form</li>
              <li>Id:: @record.Id</li>
              <li>IP:: @record.IP</li>
              <li>MemberKey:: @record.MemberKey</li>
                <li>State:: @record.State</li>
                <li>UmbracoPageId:: @record.UmbracoPageId</li>
                <li>Updated:: @record.Updated</li>
            </ul>
       </div>
  }
 catch (Exception e)
   {
     <div style="color:red">@e.Message</div>
   }
}

The Record.Id being returned is an INT and not a GUID, so how does one line up the two and retrieve the correct data?

Is there another location in memory which is storing the Record.Id?

Copy Link

Greg 9 posts 29 karma points

Jan 31, 2015 @ 00:26

I've found a short-term hack which doesnt rely on simply selecting the last record returned.

Long term this could be a problem if I have 50k records and I'm iterating over every record returned.

Looking at the database in dbo.UFRecords, I was able to find a field not detailed in the documentation, UniqueId. With this I can at least match up the proper data, but again, this is not a viable permanent solution. A comment on what is "proper" or another method being exposed which returns a single record would be helpful.

string recordIdString = TempData["Forms_Current_Record_id"].ToString();
var recordIdGuid = new Guid(recordIdString);
var recordSet = Library.GetRecordsFromForm(@formId);
foreach (dynamic record in recordSet)
{
    try 
  {
     if (record.UniqueId == recordIdGuid) {
        <div>
           <ul>
                <li>Created:: @record.Created</li>
                <li>Form:: @record.Form</li>
              <li>Id:: @record.Id</li>
              <li>IP:: @record.IP</li>
              <li>MemberKey:: @record.MemberKey</li>
                <li>State:: @record.State</li>
                <li>UmbracoPageId:: @record.UmbracoPageId</li>
                <li>Updated:: @record.Updated</li>
                <li>UniqueId:: @record.UniqueId</li>
          </ul>
       </div>
      }
 }
 catch (Exception e)
   {
     <div style="color:red">@e.Message</div>
   }

Copy Link

Dan Mulholland 2 posts 22 karma points

Jul 29, 2015 @ 15:15

0

Hi, did you ever find a solution to this issue? I'm anticipating a lot of records so eager for a longer term solution

Copy Link
is working on a reply...

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