{"id":96429,"date":"2020-10-14T16:59:36","date_gmt":"2020-10-14T07:59:36","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/bug-20201014\/"},"modified":"2021-03-08T13:57:52","modified_gmt":"2021-03-08T04:57:52","slug":"bug-20201014","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/incident\/bug-20201014\/","title":{"rendered":"Value of Numeric Row Sum of Table-type may not be Reflected in Numeric-type (Fixed)"},"content":{"rendered":"
This bug has been fixed.<\/div><\/div>\n\n\n\n

Fixed Version<\/h3>\n\n\n\n
  • Ver. 12.2.1<\/li><\/ul>\n\n\n\n

    Affected Version and Operation<\/h3>\n\n\n\n
    • Ver. 12.2.0 and later versions<\/li>
    • The aggregated value of a numeric column in a Table-type Data Item is referred to in the expression that has been set in a Numeric-type Data Item or in a Service Task (Data Assignment)<\/li><\/ul>\n\n\n\n

      Bug Details<\/h3>\n\n\n\n
      • Occurs in a workflow App that meets all of the following conditions:
        • The expression that has been set in a Numeric-type Data Item or in a Service Task (Data Assignment) includes reference to the aggregated value of a numeric column in a Table-type Data Item
          • In “Service Task (Data Assignment)”, if it updates the value of a Numeric-type Data Item<\/li><\/ul><\/li>
          • The following two values In the numeric column in the Table-type Data Item that is referenced in the expression do not match
            • Table column number<\/li>
            • Column index (0 start)<\/li><\/ul><\/li><\/ul><\/li>
            • What will occur
              • The aggregated value is not reflected in the Numeric-type Data as the item specified in the expression is not referenced<\/li><\/ul><\/li><\/ul>\n\n\n\n
                \"\"
                Column setting in Table-type Data Item<\/figcaption><\/figure><\/div>\n\n\n\n
                \"\"
                Example of a bug consequence<\/figcaption><\/figure><\/div>\n\n\n\n

                Workround\u30fbRecovery<\/h3>\n\n\n\n
                • Please avoid this problem by the following method
                  • For the column item (numeric) in Table-type whose aggregated value is referred to by the calculation expression, change the setting so that the following two values match
                    • Table column number<\/li>
                    • Column index (0 start)\/li><\/li><\/ul><\/li>
                    • You can change the display order of table columns with Drag & Drop
                      • Please note that if you are outputting the table items in “Service Task (PDF generation)”, you will need to modify the “Base PDF” according to the change<\/li><\/ul><\/li>
                      • You can change the table column number by deleting and adding the table column
                        • When adding a table item, the number of “maximum number of existing table column + 1” is automatically set<\/li><\/ul><\/li>
                        • If you find it is difficult to change the display order of table items or delete\/add them, please consider defining a new Table-type Data Item from scratch<\/li>
                        • After matching the two values of the table item, make sure that the value referenced in the calculation expression (# q_table.summary [‘5’], etc.) is also the same value (“5” part), and correct if necessary<\/li>
                        • Please Start a new Process after modifying the App and [Releasing] it<\/li><\/ul><\/li>
                        • An alternative way to workaround is to temporarily not use the value calculation expression. Please refer to the sum values in the table and enter them manually.<\/li>
                        • There is no way to avoid or recover from this problem for Processes that have already started. Consider rerunning the Process.<\/li>
                        • This bug is due to be fixed in the coming version (Ver. 12.2.1)<\/s><\/li><\/ul>\n\n\n\n

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

                          Fixed Version: Ver. 12.2.1<\/p>\n","protected":false},"author":3,"featured_media":102445,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[4680],"tags":[],"faq_section":[],"class_list":["post-96429","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-incident"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":0,"uagb_excerpt":"Fixed Version: Ver. 12.2.1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-p5j","jetpack-related-posts":[{"id":96611,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1221\/","url_meta":{"origin":96429,"position":0},"title":"v12.2.1 2020-10-25 Fixed Bug that Table Row Sum was Not Reflected in Numeric-type","author":"Hirotaka NISHI","date":"2020-10-19","format":false,"excerpt":"Fixed some bugs such as table row sum is not reflected in Numeric-type","rel":"","context":"In "Version Info"","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/version-1221-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/version-1221-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/version-1221-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/version-1221-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/version-1221-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":99135,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1230\/","url_meta":{"origin":96429,"position":1},"title":"v12.3 2021-01-17 Added Auto-step that Cooperates with kintone","author":"Hirotaka NISHI","date":"2020-12-28","format":false,"excerpt":"An auto-step that can be used as the standard in the workflow platform of Advanced or higher is added. Also, Apps in which \"Rhino\" is used in the Script Task results a setting error","rel":"","context":"In "Version Info"","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":68661,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1130\/","url_meta":{"origin":96429,"position":2},"title":"v11.3 2017-03-13: Renewing Workflow screen for Smartphones","author":"Hirotaka NISHI","date":"2017-02-28","format":false,"excerpt":"Release Overview Date Release SaaS Edition : Mon. Mar. 13th, 2017 Download Edition : None Changes to be Noted Parameter of \"option\" is obsolete in API for \"Querying for Task records operated by the User\" Change the naming of \"Process Model\" to \"Application\". We will also change related terms. Check\u2026","rel":"","context":"In "Version Info"","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":87684,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1200\/","url_meta":{"origin":96429,"position":3},"title":"v12.0 2020-05-11 Modeling Feature Completely Transits from Flash to HTML5","author":"Hirotaka NISHI","date":"2020-04-27","format":false,"excerpt":"The Flash version of the modeling function will be abolished and will be fully migrated to the HTML5 version. Also, snapshots will be automatically saved while editing an App.","rel":"","context":"In "Version Info"","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/version-1200-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/version-1200-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/version-1200-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/version-1200-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/version-1200-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":76339,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-data-assignment\/","url_meta":{"origin":96429,"position":4},"title":"Update Data","author":"Hirotaka NISHI","date":"2021-09-28","format":false,"excerpt":"Automatically updates Business Data with the specified value or the evaluation result of the formula. Capable of updating several Data Items also in one automatic Step.","rel":"","context":"In "BPMN Icons"","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/bpmn-icon-service-task-update-data-2024.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":96429,"position":5},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In "Data Items"","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/bug-report-en-1200x675-1.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=96429"}],"version-history":[{"count":4,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96429\/revisions"}],"predecessor-version":[{"id":103095,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/96429\/revisions\/103095"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/102445"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=96429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=96429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=96429"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=96429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}