Copied to clipboard

Flag this post as spam?

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


  • Isaack Rasmussen 14 posts 34 karma points
    Jun 01, 2015 @ 16:57
    Isaack Rasmussen
    0

    Missing fields when retrieving records

    When I try to get all records from a form

    var recs=Umbraco.Forms.Mvc.DynamicObjects.Library.GetRecordsFromForm(uForm.Id.ToString());

     

    Alot of the records will only contain one Record field and I can't find the record data. However when looking in Forms Admin module, they all show fine. I've also tried without the Dynamic Object library and through RecordStorage but its the same thing.

    I'm using UmbracoForms.Package.4.0.3

    Does any of you know know what I do wrong?

  • Comment author was deleted

    Jun 01, 2015 @ 17:00

    So the records returned only contain data for a single field or am I misunderstanding the issue?  

  • Isaack Rasmussen 14 posts 34 karma points
    Jun 02, 2015 @ 10:39
    Isaack Rasmussen
    0

    Actually, I'm only getting the header for that single field and no data at all, RecordData is also empty.

  • Isaack Rasmussen 14 posts 34 karma points
    Jun 02, 2015 @ 12:57
    Isaack Rasmussen
    0

    @Tim 

    Could it be a security context? I just realized an interesting pattern, it is only my own test entries that I see. So all the empty records are all the ones I didn't enter myself.

     

  • Comment author was deleted

    Jun 02, 2015 @ 12:58

    Hmm doubt it since we don't check for that, will see if I can reproduce

  • Isaack Rasmussen 14 posts 34 karma points
    Jun 02, 2015 @ 13:05
    Isaack Rasmussen
    0

    Perhaps, you don't even need to try, I just checked the table: UFRecordDataString and it doesn't seem to contain data for any of the missing entries. So somehow my backup file that I restored from isn't complete. It does seem to contain all the entries in UFRecords

  • Isaack Rasmussen 14 posts 34 karma points
    Jun 02, 2015 @ 13:31
    Isaack Rasmussen
    0

    I found the data in the field RecordData from the UFRecords table. However the RecordData member is still empty and calling GenerateRecordDataAsJson() returns

    {'d1e65e3e-da60-483c-92e6-b0a46b82cad5':''}

    Which is also the ID for the one field I can get from the API with no value. The RecordData in the table starts with that ID but has value for that one and all the other fields.

    Any clue to why its like this? Is there anything I can call to populate the various class members.

  • Frederik Raabye 72 posts 276 karma points MVP 2x c-trib
    Aug 10, 2015 @ 11:57
    Frederik Raabye
    0

    Isaack did you find a solution to this?

    I am experiencing something similar with V7.2.8 and Forms 4.1.4 via both Library.GetXXX and RecordStorage.GetRecordByUniqueId for a single record.

  • Isaack Rasmussen 14 posts 34 karma points
    Aug 10, 2015 @ 12:10
    Isaack Rasmussen
    0

    Not really, in the end I gave up going that route... The last thing I did was extracting data from the JSON RecordData field.

  • Frederik Raabye 72 posts 276 karma points MVP 2x c-trib
    Aug 10, 2015 @ 12:45
    Frederik Raabye
    0

    Ok, thanks. It is incredibly frustrating ... I am currently trying to use a combination of RecordStorage and FieldStorage to manually build a dictionary.

  • Isaack Rasmussen 14 posts 34 karma points
    Aug 10, 2015 @ 12:55
    Isaack Rasmussen
    0

    Extremely frustrating! And this was not the only issue I ran into which ended up making it much-much more time consuming compared to a manual solution. The biggest problem was the documentation which looks very incomplete.

    I did a similar thing but used AllFields from GetForms().

  • Matthew Kirschner 323 posts 611 karma points
    Jul 21, 2017 @ 19:11
    Matthew Kirschner
    0

    Two years later and this is still an issue on Forms 6.0.2.

    I'm making a call to Umbraco.Forms.Mvc.DynamicObjects.Library.GetRecordsFromForm() . Some forms spit out all their fields and values well enough (though checkbox fields seem to be missing captions) whereas other forms only spit out the values for a few fields out of many.

    E.g., I have a form with the following fields:

    • Name
    • Phone
    • Email
    • Start Date
    • End Date

    Yet I'm only seeing the Name, Start Date, and End Dates show up after making the fetch records call.

    I'm not sure what's going on here.

Please Sign in or register to post replies

Write your reply to:

Draft