{"id":3637,"date":"2016-07-01T03:00:12","date_gmt":"2016-06-30T19:00:12","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3637"},"modified":"2019-10-24T16:21:09","modified_gmt":"2019-10-24T08:21:09","slug":"submission-type","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/07\/01\/submission-type\/","title":{"rendered":"Submission Type"},"content":{"rendered":"<p>We will introduce Submission Type about data filling of FineReport <a title=\"reporting tools\" href=\"\/en\/\" target=\"_blank\"><span style=\"color: blue;\">reporting tool<\/span><\/a> in this article.<\/p>\n<h3>1. Intelligent submission<\/h3>\n<p>In intelligent submission, the backstage will judges insert, update and delete. If your filling template has two or more demands aforesaid, you can select intelligent submission type.<\/p>\n<p>If you have inserted several pieces of blank data but fail to edit these blank rows, FineReport will identify these record values as NULL. These records will not be stored in database (i.e., blank records not stored).<\/p>\n<h3>2. Insert submission<\/h3>\n<p>In insert submission, only insert operation is made. Therefore, it is generally applied in blank information collection table. If insert submission is applied for templates showing original data, the original records will be re-inserted to the database, causing data repetition; and if you have defined a primary key in the database table, in insert submission, submission will fail (i.e., index conflict).<\/p>\n<p><span style=\"color: red;\">Note: Similarly, in insert submission, blank records will not be stored in database.<\/span><\/p>\n<h3>3. Update submission<\/h3>\n<p>Update submission is to update original data. Therefore, original data must be displayed in the template. In addition, check a column in the <span style=\"color: blue;\">Report Filling Attribute<\/span> as primary key, and the data inside cannot be changed; otherwise, update submission will be changed to insert submission.<\/p>\n<p><span style=\"color: red;\">Note: Primary keys in Report Filling Attribute and database are different. Report primary key is to operate corresponding data in Update Submission and Delete Submission. If Delete Submission or Update Submission is not set, primary key will operate all data.<\/span><\/p>\n<h3>4. Delete submission<\/h3>\n<p>Similar to Update Submission, you need to check a column in the Report Filling Attribute as primary key as the template also needs to display original data.<\/p>\n<p><span style=\"color: red;\">Note: To improve report storage efficiency, be cautious when using Intelligent Submission. In Intelligent Submission, during data submission, the system will judge whether there is a report primary key. If so, take update submission, if not, take insert submission, thus reducing report storage efficiency. Therefore, when only one submission is used, select corresponding submission type.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will introduce Submission Type about data filling of&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3637"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3637"}],"version-history":[{"count":2,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3637\/revisions"}],"predecessor-version":[{"id":8518,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3637\/revisions\/8518"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}