{"id":50601,"date":"2022-03-16T09:34:15","date_gmt":"2022-03-16T16:34:15","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=50601"},"modified":"2022-03-16T12:20:44","modified_gmt":"2022-03-16T19:20:44","slug":"updating-batch-instance-as-deleted","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/","title":{"rendered":"Updating Batch Instance as Deleted"},"content":{"rendered":"

Applies to: <\/strong>Transact all versions<\/em><\/p>\n

Updating the batch instances as DELETED in the Ephesoft <\/strong>database will cause duplicate jobs to be generated as NEW.<\/p>\n

To expedite the deletion of batch instance jobs, users can update the batch_status<\/strong> column of the dbo.batch_instance<\/strong> table from the Ephesoft<\/strong> database with the condition of last_modified<\/strong> date.<\/p>\n

<\/a>User Instructions<\/h2>\n

Sample query:<\/strong><\/p>\n

UPDATE Ephesoft.dbo.batch_instance<\/strong><\/p>\n

set batch_status = ‘DELETED’<\/strong><\/p>\n

WHERE last_modified < ‘2021-12-31 23:59’<\/strong><\/p>\n

This will automatically update the selected batches chosen by the SQL script in the Ephesoft UI as expected. However, it will also cause the same batch instances to be recreated as NEW batch instance jobs.<\/p>\n

To bypass this from happening, perform the following before running the UPDATE script or manually updating the batch_status<\/strong> column for individual batch instances to DELETED:<\/p>\n

    \n
  1. Find the original Batch Instance<\/strong> drop folders inside the Batch Classes<\/strong> and delete the folders for those jobs you want to delete.<\/li>\n
  2. Find the Batch Instance<\/strong> jobs from inside the \/Shared Folders\/ephesoft-system-folder<\/strong> and delete the batch instance folders for the jobs you want to delete.<\/li>\n<\/ol>\n

    Note:<\/strong> Doing both of these actions before updating the SQL database table will ensure that you do not see any duplicate jobs.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Applies to: Transact all versions Updating the batch instances as DELETED in the Ephesoft database will cause duplicate jobs to […]<\/p>\n","protected":false},"author":93,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12382],"tags":[1430],"yoast_head":"\nUpdating Batch Instance as Deleted | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Updating Batch Instance as Deleted\" \/>\n<meta property=\"og:description\" content=\"Applies to: Transact all versions Updating the batch instances as DELETED in the Ephesoft database will cause duplicate jobs to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-16T16:34:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-16T19:20:44+00:00\" \/>\n<meta name=\"author\" content=\"nabinbhattachary\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"nabinbhattachary\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/\",\"name\":\"Updating Batch Instance as Deleted | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2022-03-16T16:34:15+00:00\",\"dateModified\":\"2022-03-16T19:20:44+00:00\",\"author\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/c3ab270d203a126d32f8a6ce83fd5704\"},\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Updating Batch Instance as Deleted\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/c3ab270d203a126d32f8a6ce83fd5704\",\"name\":\"nabinbhattachary\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bce398ad23484e2a29678a6d1732f777?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bce398ad23484e2a29678a6d1732f777?s=96&r=g\",\"caption\":\"nabinbhattachary\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Updating Batch Instance as Deleted | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Updating Batch Instance as Deleted","og_description":"Applies to: Transact all versions Updating the batch instances as DELETED in the Ephesoft database will cause duplicate jobs to […]","og_url":"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/","og_site_name":"Ephesoft Docs","article_published_time":"2022-03-16T16:34:15+00:00","article_modified_time":"2022-03-16T19:20:44+00:00","author":"nabinbhattachary","twitter_card":"summary_large_image","twitter_misc":{"Written by":"nabinbhattachary","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/","url":"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/","name":"Updating Batch Instance as Deleted | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2022-03-16T16:34:15+00:00","dateModified":"2022-03-16T19:20:44+00:00","author":{"@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/c3ab270d203a126d32f8a6ce83fd5704"},"breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/updating-batch-instance-as-deleted\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Updating Batch Instance as Deleted"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/c3ab270d203a126d32f8a6ce83fd5704","name":"nabinbhattachary","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bce398ad23484e2a29678a6d1732f777?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bce398ad23484e2a29678a6d1732f777?s=96&r=g","caption":"nabinbhattachary"}}]}},"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/50601"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/users\/93"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=50601"}],"version-history":[{"count":3,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/50601\/revisions"}],"predecessor-version":[{"id":50605,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/50601\/revisions\/50605"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=50601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/categories?post=50601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/tags?post=50601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}