Unique ID does not remain constant

  • SumSolTrain
    Asked on September 18, 2014 at 2:44 AM

    Unique ID does not remain constant Image 1 Screenshot 20

    The clone form ID 42431153944956 with SID - 285387145665958892 shows the Parent ID different from the others .

     

     

  • Carina
    Replied on September 18, 2014 at 10:47 AM

    I could not locate submission with ID 285387145665958892 as part of the form 42431153944956 (Clone of Free to Grow-WorkQ® Performance Evaluation Template,{real form } ).
    Was it erased? If so I kindly ask you, if possible, to send us the submission list to our email support@jotform.com so we can investigate further this situation.  

    Please add the thread ID (430730)to the subject of the email, so we can track better the thread.

    Also I could not locate the Parent ID field. Was it also erased?

    We'll wait for more details to proceed.

     

    Let us know if we can assist you.

  • SumSolTrain
    Replied on September 18, 2014 at 11:01 AM
    Hi

    I can view the form from (view submissions) that I have attached,
    We got the same kind of problem with other submission ID’s also.
    Thanks.

    ...
  • jedcadorna
    Replied on September 18, 2014 at 12:48 PM

    Sorry but I didn't quite understand when you say unique ID is not constant are you saying that the value of your unique ID is different? I do apologize if I didn't get your question. I'm trying to understand the image and I was searching it but I didn't find any result.

  • SumSolTrain
    Replied on September 19, 2014 at 4:12 AM

     

    Hi,

     

    If you run the equivalent query below you side you will see that the same parent_id it referencing two differnet for objects.

     

    It should not – according to jotform – do this.

     

    This is a major problem that requires urgent resolution.

     

    Kind Regards

     

    John Kiln

     

     

    Select *  FROM [FreeToGrow].[dbo].[Submissions_JSon]

      where FormID = '41892132684560'

      and parent_ID = 245

      and CreatedAt>'2014-08-20'

     

        Select *  FROM [FreeToGrow].[dbo].[Submissions_JSon]

      where FormID = '42431153944956'

      and parent_ID = 245

     

      

  • SumSolTrain
    Replied on September 19, 2014 at 4:13 AM

    FormID = 42431153944956 is A CLONE of 41892132684560

  • Steve VP of Sales Operations
    Replied on September 19, 2014 at 4:45 AM

    Hello-

    Thanks for bringing this to our attention. I've escalated your request to development so they can look into this further. Thanks.

  • SumSolTrain
    Replied on September 22, 2014 at 3:36 AM

    Hi All,

    any response from your development team. We are still waiting for this to be fixed.

    Thanks,

  • Ben
    Replied on September 22, 2014 at 9:36 AM

    Hi,

    Our developers have told us that you have emailed the API team next to creating this ticket so they will be responding to you over that email in order to have all the details in one place.

    They will get back to you as soon as the issue is fixed or if there is any update in regards to the issue, in the meantime I would suggest to wait for their response.

    If you however have any new discoveries or data to send them that would help resolve the issue, feel free to contact them by replying / forwarding your email through the previous email conversation with them so it is easy to follow up on.

    Best Regards,
    Ben