Uploaded image for project: 'i2b2 Web Client'
  1. i2b2 Web Client
  2. WEBCLIENT-136

Date Constraints lost in webclient when executing a query created in workbench

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.06
    • 1.7.07
    • Web Client
    • None
    • Query Tool
    • Constraints - Date
    • i2b2 Web Client
    • All databases
    • All Web Browsers
    • Hide
      This can be reproduced in both the i2b2 demo and test environments.

      As the description states the date constraints are in the xml that is returned when the previous query is dropped into the query tool but it is not updating the constraints in the Date Constraint window. As a result when the query is run there are no date constraints defined in the new query.

      STEPS TO REPRODUCE:

      1. Log into the Workbench.

      2. Drag a concept to the Query Tool and add a date constraint.

      3. Run the query.

      4. Log into the Web Client.

      5. In Previous Queries, identify the query you just ran in the Workbench.

      6. Drag it to the Query Tool.

      7. Notice the "Date" button does not have an underline, indicating it has a date constraint.

      8. Open the Date Constraint window and notice the dates defined on the original query do not appear.

      9. Click on Cancel to close the Date Constraint window.

      10. Look at the XML message received when the query was dropped in the Query Tool, you will notice the correct date constraints are included in the message.

      11. Run the query.

      12. Look at the request xml that was sent when running the query and notice there are no date constraints defined in the xml.
      Show
      This can be reproduced in both the i2b2 demo and test environments. As the description states the date constraints are in the xml that is returned when the previous query is dropped into the query tool but it is not updating the constraints in the Date Constraint window. As a result when the query is run there are no date constraints defined in the new query. STEPS TO REPRODUCE: 1. Log into the Workbench. 2. Drag a concept to the Query Tool and add a date constraint. 3. Run the query. 4. Log into the Web Client. 5. In Previous Queries, identify the query you just ran in the Workbench. 6. Drag it to the Query Tool. 7. Notice the "Date" button does not have an underline, indicating it has a date constraint. 8. Open the Date Constraint window and notice the dates defined on the original query do not appear. 9. Click on Cancel to close the Date Constraint window. 10. Look at the XML message received when the query was dropped in the Query Tool, you will notice the correct date constraints are included in the message. 11. Run the query. 12. Look at the request xml that was sent when running the query and notice there are no date constraints defined in the xml.
    • Hide
      TEST STATUS: Completed
      COMPLETION DATE: 12/15/2015

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      Test Date: 12/15/2015
      Build Number: 1.7.07.0005
      Test Status: Completed (Passed Testing)

      Clients Tested :
           i2b2 Web Client
           i2b2 Workbench

      Environments Tested :
           Browsers: Chrome, Firefox, Internet Explorer, and Safari
           Databases: Not applicable for this test
           Client OS: Windows and Macintosh (Release 1.7.06)

      Test Comments:
      Tested with the latest Web Client build and it appears to be working correctly. Queries with date constraints that were initially run in the Workbench will now run in Web Client with no problem.

      ISSUES FOUND:
      A issue was found but it is related to a new feature that adds date constraints to the item level (WEBCLIENT-162). The issue found will be tracked in WEBCLIENT-162 and since it is not directly related to this issue, this one will be updated to RESOLVED.
      Show
      TEST STATUS: Completed COMPLETION DATE: 12/15/2015 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Test Date: 12/15/2015 Build Number: 1.7.07.0005 Test Status: Completed (Passed Testing) Clients Tested :      i2b2 Web Client      i2b2 Workbench Environments Tested :      Browsers: Chrome, Firefox, Internet Explorer, and Safari      Databases: Not applicable for this test      Client OS: Windows and Macintosh (Release 1.7.06) Test Comments: Tested with the latest Web Client build and it appears to be working correctly. Queries with date constraints that were initially run in the Workbench will now run in Web Client with no problem. ISSUES FOUND: A issue was found but it is related to a new feature that adds date constraints to the item level ( WEBCLIENT-162 ). The issue found will be tracked in WEBCLIENT-162 and since it is not directly related to this issue, this one will be updated to RESOLVED.
    • 1.7.07.0005

    Description

      When you run a query in the workbench with a date constraint, these constraints are not maintained when you use the query in the Web Client. The date constraints do appear in the xml received when the item is dropped but they do not appear in the panel next to the item name. If you run the query it will not have the date constraints in the sent xml. Also if you go into the date constraint window the dates will not appear.

      IMPORTANT: This issue is also a problem in the Workbench. CORE-191 has been entered to address this issue.

      Attachments

        Issue Links

          related to

          Bug - A problem which impairs or prevents the functions of the product. CORE-191 Date Constraints lost in workbench when executing a query created in webclient

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            jmd86 Janice Donahoe created issue -
            jmd86 Janice Donahoe made changes -
            Field Original Value New Value
            Link This issue related to CORE-191 [ CORE-191 ]
            jmd86 Janice Donahoe made changes -
            Fix Version/s 1.7.07 [ 10203 ]
            Reproduction Notes This can be reproduced in both the i2b2 demo and test environments.

            As the description states the date constraints are in the xml that is returned when the previous query is dropped into the query tool but it is not updating the constraints in the Date Constraint window. As a result when the query is run there are no date constraints defined in the new query.

            STEPS TO REPRODUCE:

            1. Log into the Workbench.

            2. Drag a concept to the Query Tool and add a date constraint.

            3. Run the query.

            4. Log into the Web Client.

            5. In Previous Queries, identify the query you just ran in the Workbench.

            6. Drag it to the Query Tool.

            7. Notice the "Date" button does not have an underline, indicating it has a date constraint.

            8. Open the Date Constraint window and notice the dates defined on the original query do not appear.

            9. Click on Cancel to close the Date Constraint window.

            10. Look at the XML message received when the query was dropped in the Query Tool, you will notice the correct date constraints are included in the message.

            11. Run the query.

            12. Look at the request xml that was sent when running the query and notice there are no date constraints defined in the xml.
            Assignee Nich [ nich ]
            Description When you run a query in the workbench with a date constraint, these constraints are not maintained when you use the query in the Web Client. The date constraints do appear in the request xml but they do not appear in the panel next to the item name. If you run the query it will not have the date constraints in the sent xml. Also if you go into the date constraint window the dates will not appear.

            IMPORTANT: This issue is also a problem in the Workbench. CORE-191 has been entered to address this issue.
            		When you run a query in the workbench with a date constraint, these constraints are not maintained when you use the query in the Web Client. The date constraints do appear in the xml received when the item is dropped but they do not appear in the panel next to the item name. If you run the query it will not have the date constraints in the sent xml. Also if you go into the date constraint window the dates will not appear.

            IMPORTANT: This issue is also a problem in the Workbench. CORE-191 has been entered to address this issue.
            i2b2 Sponsored Project/s i2b2 Web Client [ 10197 ]
            Status New [ 10000 ] Open [ 1 ]
            nich Nich added a comment -
            The webclient and workbench are handling dates differently in the request XML for dates.

            The webclient constructs the following XML:

             <panel> ...
                                        <panel_date_from>1979-12-01T00:00:00.000-05:00</panel_date_from>
                                        <panel_date_to>2005-12-07T00:00:00.000-05:00</panel_date_to>

            The workbench constructs the following XML:

                                    <panel> ...
                                        <item>
                                            <constrain_by_date>
                                                <date_from>1979-12-01T00:00:00-05:00</date_from>
                                                <date_to>2005-12-07T00:00:00-05:00</date_to>
                                            </constrain_by_date>

            For previous queries, the webclient only reads <panel><panel_date_from>, and the workbench only reads <panel><item><constrain_by_date><date_from>
            nich Nich added a comment - The webclient and workbench are handling dates differently in the request XML for dates. The webclient constructs the following XML:  <panel> ...                             <panel_date_from>1979-12-01T00:00:00.000-05:00</panel_date_from>                             <panel_date_to>2005-12-07T00:00:00.000-05:00</panel_date_to> The workbench constructs the following XML:                         <panel> ...                             <item>                                 <constrain_by_date>                                     <date_from>1979-12-01T00:00:00-05:00</date_from>                                     <date_to>2005-12-07T00:00:00-05:00</date_to>                                 </constrain_by_date> For previous queries, the webclient only reads <panel><panel_date_from>, and the workbench only reads <panel><item><constrain_by_date><date_from>
            nich Nich made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            nich Nich made changes -
            Fix Version/s 1.7.08 [ 10205 ]
            Fix Version/s 1.7.07 [ 10203 ]
            nich Nich added a comment -
            Fix will be deferred to 1.7.08 since Date Constraints will be reworked in web client.
            nich Nich added a comment - Fix will be deferred to 1.7.08 since Date Constraints will be reworked in web client.
            nich Nich made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            nich Nich added a comment -
            I was able to fix this with backwards-support in 1.7.07. Moving this back to resolved in 1.7.07.
            nich Nich added a comment - I was able to fix this with backwards-support in 1.7.07. Moving this back to resolved in 1.7.07.
            nich Nich made changes -
            Fix Version/s 1.7.07 [ 10203 ]
            Fix Version/s 1.7.08 [ 10205 ]
            nich Nich made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            nich Nich made changes -
            Assignee Nich [ nich ] Janice Donahoe [ jmd86 ]
            Status In Progress [ 3 ] Ready to Test [ 10001 ]
            jmd86 Janice Donahoe made changes -
            Status Ready to Test [ 10001 ] Testing [ 10002 ]
            jmd86 Janice Donahoe made changes -
            Build Number/s (Testing) 1.7.07.0005
            Testing Notes TEST STATUS: Completed
            COMPLETION DATE: 12/15/2015

            ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

            Test Date: 12/15/2015
            Build Number: 1.7.07.0005
            Test Status: Completed (Passed Testing)

            Clients Tested :
                 i2b2 Web Client
                 i2b2 Workbench

            Environments Tested :
                 Browsers: Chrome, Firefox, Internet Explorer, and Safari
                 Databases: Not applicable for this test
                 Client OS: Windows

            Test Comments:
            Tested with the latest Web Client build and it appears to be working correctly. Queries with date constraints that were initially run in the Workbench will now run in Web Client with no problem.

            ISSUES FOUND:
            A issue was found but it is related to a new feature that adds date constraints to the item level (WEBCLIENT-162). The issue found will be tracked in WEBCLIENT-162 and since it is not directly related to this issue, this one will be updated to RESOLVED.
            Status Testing [ 10002 ] Testing [ 10002 ]
            jmd86 Janice Donahoe made changes -
            Testing Notes TEST STATUS: Completed
            COMPLETION DATE: 12/15/2015

            ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

            Test Date: 12/15/2015
            Build Number: 1.7.07.0005
            Test Status: Completed (Passed Testing)

            Clients Tested :
                 i2b2 Web Client
                 i2b2 Workbench

            Environments Tested :
                 Browsers: Chrome, Firefox, Internet Explorer, and Safari
                 Databases: Not applicable for this test
                 Client OS: Windows

            Test Comments:
            Tested with the latest Web Client build and it appears to be working correctly. Queries with date constraints that were initially run in the Workbench will now run in Web Client with no problem.

            ISSUES FOUND:
            A issue was found but it is related to a new feature that adds date constraints to the item level (WEBCLIENT-162). The issue found will be tracked in WEBCLIENT-162 and since it is not directly related to this issue, this one will be updated to RESOLVED.             		TEST STATUS: Completed
            COMPLETION DATE: 12/15/2015

            ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

            Test Date: 12/15/2015
            Build Number: 1.7.07.0005
            Test Status: Completed (Passed Testing)

            Clients Tested :
                 i2b2 Web Client
                 i2b2 Workbench

            Environments Tested :
                 Browsers: Chrome, Firefox, Internet Explorer, and Safari
                 Databases: Not applicable for this test
                 Client OS: Windows and Macintosh (Release 1.7.06)

            Test Comments:
            Tested with the latest Web Client build and it appears to be working correctly. Queries with date constraints that were initially run in the Workbench will now run in Web Client with no problem.

            ISSUES FOUND:
            A issue was found but it is related to a new feature that adds date constraints to the item level (WEBCLIENT-162). The issue found will be tracked in WEBCLIENT-162 and since it is not directly related to this issue, this one will be updated to RESOLVED.
            Status Testing [ 10002 ] Testing [ 10002 ]
            jmd86 Janice Donahoe made changes -
            Build Number (Fixed) 1.7.07.0005
            Resolution Fixed [ 1 ]
            Status Testing [ 10002 ] Resolved [ 5 ]
            jmd86 Janice Donahoe added a comment - - edited
            On 01/22/2016, the 1.7.07 Release was made available at the following locations.

            https://www.i2b2.org/software/
             - zip files for release 1.7.07 are available on this site. This includes both the code and documentation.

            https://github.com/i2b2
             - source code has been tagged with v1.7.07.
            jmd86 Janice Donahoe added a comment - - edited On 01/22/2016, the 1.7.07 Release was made available at the following locations. https://www.i2b2.org/software/  - zip files for release 1.7.07 are available on this site. This includes both the code and documentation. https://github.com/i2b2  - source code has been tagged with v1.7.07.
            jmd86 Janice Donahoe made changes -
            Status Resolved [ 5 ] Closed [ 6 ]

            People

              jmd86 Janice Donahoe
              jmd86 Janice Donahoe
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: