Home
Extended ECM
API, SDK, REST and Web Services
LiveReports/Forms
unknown
Message from Rao, Suthindran via eLinkI am trying to write a report on form data, whose forms are created with Submission Mechanism "SQL Table" and Revision Mechanism "Livelink Version". I would like to select data based on the date the data was submitted. Is date of submission stored in LL database...is there a way to get this information ?thanks in advance.Suthindran
Find more posts tagged with
Comments
Greg_Petti_(gpetti_(Delete)_2694690)
In case no one has mailed you on this.Only the revision changes are captured in dversdata, so the date of a submit action is not captured in the corresponding SQL table created by the form template. One 'kludgy' way to do this is to create your own date field in the template (and underlying SQL table). Using a custom form view this can be hidden from the user if necessary. Also using a custom form view, some javascript can be added so that when the user submits the form, the date field is updated with the current date (either using a Javascript date object or the _update... method created by Livelink for date fields) which is then stored by Livelink in the data table.