topic RE: Where are the field values stored? in Product Forum

Where are the field values stored?

zdenek.kabatek — Fri, 28 May 2021 12:37:00 GMT

Hi,

when a user in Interact saves a form as a draft is the draft version saved in database or somewhere? Can I query the status of the form of a user directly in database?

Regards,

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

RE: Where are the field values stored?

AdrianWhite — Tue, 08 Jun 2021 16:06:00 GMT

Hi Zdenek,

Yes they are stored in the Interact database. They are stored in the dbo.UserRequests table (which is where all requests are stored). The 'Status' column denotes the status of the submission, 0 being submitted and 4 being draft.

Hope this helps.

Cheers,

Adrian

------------------------------
Adrian White
Head of Product Consultancy
Blue Prism Ltd
------------------------------

RE: Where are the field values stored?

zdenek.kabatek — Fri, 11 Jun 2021 08:08:00 GMT

Hi, Adrian,

thanks for the info I already found it.

Regards,

Zdenek

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------