Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-664

San Luis Obispo - Column Header is not pulling correctly

    Details

    • Environment:
      Production
    • Categories:
      Platform
    • Company:
      County of San Luis Obispo
    • Reported by:
      White Label

      Description

      When pulling the AFLAC Certification New CRITIAL ILLNESS CERTIFICATION: I Certify I am Actively as work. If electing spouse coverage... on a standard report the column header is cutting off (see below) and it is inserting "SPCHAR511134" It also does the same thing on the other question for Accident.

      I don't know if there is a character limit but if there is can we increase it.

        Attachments

          Activity

          dkulling Debbie Kulling created issue -
          Hide
          Prashant.samal Prashant Samal (Inactive) added a comment -

          Please check this

          __________________________
          Satya Amruta Lohiya

          Show
          Prashant.samal Prashant Samal (Inactive) added a comment - Please check this __________________________ Satya Amruta Lohiya
          Prashant.samal Prashant Samal (Inactive) made changes -
          Field Original Value New Value
          Assignee Satya [ ID10004 ] Amruta Lohiya [ amruta.baheti ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Workflow 0803 Copy of WB: Bugs Project Management Workflow [ 66741 ] 2203 WB: Bugs Project Management Workflow [ 67037 ]
          Hide
          dkulling Debbie Kulling added a comment -

          Please provide update on this ticket

          Show
          dkulling Debbie Kulling added a comment - Please provide update on this ticket
          amruta.lohiya Amruta Lohiya made changes -
          Assignee Amruta Lohiya [ amruta.baheti ] Jyoti Agrawal [ jyoti.agrawal ]
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          Hide
          jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

          Hi Debbie Kulling,

          The field selected has character more than 128 and report service tool has limitation of 128 characters.

          If we try to extend beyond 128 characters system throws error. So we trim the names beyond 128 characters in the code logic.

          Reason of "SPCHAR511134" appended in header name

          If two or more fields have similar name up-to 128 characters, then on trimming all will become same name and system will throw error again. So internally we append some random codes that distinguish such field names with each other.

          If those fields are really required to be shown with complete name, then we can do more R&D if this is anyhow possible. But we are not sure on this.

          Do let us know your views

          Thanks,

          Jyoti Agrawal

          cc: Amruta Lohiya

           

          Show
          jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Debbie Kulling , The field selected has character more than 128 and report service tool has limitation of 128 characters. If we try to extend beyond 128 characters system throws error. So we trim the names beyond 128 characters in the code logic. Reason of "SPCHAR511134" appended in header name :  If two or more fields have similar name up-to 128 characters, then on trimming all will become same name and system will throw error again. So internally we append some random codes that distinguish such field names with each other. If those fields are really required to be shown with complete name, then we can do more R&D if this is anyhow possible. But we are not sure on this. Do let us know your views Thanks, Jyoti Agrawal cc: Amruta Lohiya  
          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Assignee Jyoti Agrawal [ jyoti.agrawal ] Debbie Kulling [ dkulling ]
          jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 04/Apr/18 06:05 AM
          • Time Spent:
            2h
             

            Issue analysis

            RDL  R&D

            Jira update

          jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 111394 [ 111394 ]
          dkulling Debbie Kulling made changes -
          Attachment image-2018-04-04-10-17-31-138.png [ 75833 ]
          Hide
          dkulling Debbie Kulling added a comment -

          Would it be possible to reformat the question somehow from

          To:

          CRITICAL ILLNESS CERTIFICATION:

          I certify I am actively at work.  If electing....

          That way the report would only pull "CRITICAL ILLNESS CERTIFICATION:" as the report column header

          Show
          dkulling Debbie Kulling added a comment - Would it be possible to reformat the question somehow from To: CRITICAL ILLNESS CERTIFICATION: I certify I am actively at work.  If electing.... That way the report would only pull "CRITICAL ILLNESS CERTIFICATION:" as the report column header
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 04/Apr/18 09:24 PM
          • Time Spent:
            0.75h
             

            Discussion with Jyoti 

            Check Error log

          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
          Time Spent 2h [ 7200 ] 2.75h [ 9900 ]
          Worklog Id 111448 [ 111448 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Assignee Debbie Kulling [ dkulling ] Jyoti Agrawal [ jyoti.agrawal ]
          Hide
          amruta.lohiya Amruta Lohiya added a comment -

          Swapnil Pandhare

          Please modify the question

          Show
          amruta.lohiya Amruta Lohiya added a comment - Swapnil Pandhare Please modify the question
          amruta.lohiya Amruta Lohiya made changes -
          Assignee Jyoti Agrawal [ jyoti.agrawal ] Swapnil Pandhare [ swapnil.pandhare ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Workflow 2203 WB: Bugs Project Management Workflow [ 67037 ] 0604 Issues Management Workflow [ 68249 ]
          Hide
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          Hi Debbie Kulling

          We cannot format/modify radio group label in above mentioned way. 

          But, we can add a paragraph control and add formatted text in that. Below paragraph control , we can place radio group control below paragraph. This can be done by editing form from website.

           

          Please let us know if you have more questions on this.

          Thanks,

          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Debbie Kulling ,  We cannot format/modify radio group label in above mentioned way.  But, we can add a paragraph control and add formatted text in that. Below paragraph control , we can place radio group control below paragraph. This can be done by editing form from website.   Please let us know if you have more questions on this. Thanks, Swapnil P.
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 10/Apr/18 05:49 AM
          • Time Spent:
            0.5h
             
            <No comment>
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 2.75h [ 9900 ] 3.25h [ 11700 ]
          Worklog Id 111919 [ 111919 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Status In Development [ 10007 ] Development on Hold [ 11608 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Debbie Kulling [ dkulling ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status Development on Hold [ 11608 ] In Development [ 10007 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status In Development [ 10007 ] In Analysis [ 10008 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status In Analysis [ 10008 ] Waiting for Input [ 11502 ]
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Hi Debbie Kulling

          Would you still need Dev to add a Paragraph control and add for Formatted text?

          Let me know either way so I can close/keep it open.

          Thanks!
          Monika

           

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Hi  Debbie Kulling Would you still need Dev to add a Paragraph control and add for Formatted text? Let me know either way so I can close/keep it open. Thanks! Monika  
          Hide
          dkulling Debbie Kulling added a comment - - edited

          Can you mock up what this will look like in a copy so I can get BCC's approval

          Show
          dkulling Debbie Kulling added a comment - - edited Can you mock up what this will look like in a copy so I can get BCC's approval
          dkulling Debbie Kulling made changes -
          Assignee Debbie Kulling [ dkulling ] Swapnil Pandhare [ swapnil.pandhare ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status Waiting for Input [ 11502 ] In Analysis [ 10008 ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Niteen Surwase [ niteen.surwase ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Hide
          niteen.surwase Niteen Surwase (Inactive) added a comment -

          Hi Debbie Kulling

          Please find the mock ups for the field mentioned above.

          Please let us know if anything needs to change in above mock up.

          Thanks,

          Niteen S.

          CC; Swapnil Pandhare Satya

          Show
          niteen.surwase Niteen Surwase (Inactive) added a comment - Hi Debbie Kulling Please find the mock ups for the field mentioned above. Please let us know if anything needs to change in above mock up. Thanks, Niteen S. CC; Swapnil Pandhare Satya
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Assignee Niteen Surwase [ niteen.surwase ] Debbie Kulling [ dkulling ]
          Status In Analysis [ 10008 ] Waiting for Input [ 11502 ]
          niteen.surwase Niteen Surwase (Inactive) logged work - 26/Apr/18 06:05 AM
          • Time Spent:
            2.5h
             

            Creating Mock up on Production Form Builder

            Discussion with Swapnil

            Ticket Update

          niteen.surwase Niteen Surwase (Inactive) made changes -
          Time Spent 3.25h [ 11700 ] 5.75h [ 20700 ]
          Worklog Id 114274 [ 114274 ]
          Hide
          dkulling Debbie Kulling added a comment -

          I am waiting on approval from the client

          Show
          dkulling Debbie Kulling added a comment - I am waiting on approval from the client
          Hide
          dkulling Debbie Kulling added a comment -

          Please proceed with your suggestion above.  I do want to make sure that you know that this question is tied to eligibility.  I want to make sure that this change will not impact any eligibility for any enrollments.

          Show
          dkulling Debbie Kulling added a comment - Please proceed with your suggestion above.  I do want to make sure that you know that this question is tied to eligibility.  I want to make sure that this change will not impact any eligibility for any enrollments.
          dkulling Debbie Kulling made changes -
          Assignee Debbie Kulling [ dkulling ] Niteen Surwase [ niteen.surwase ]
          pratap.patil Pratap Patil (Inactive) logged work - 04/May/18 11:01 PM
          • Time Spent:
            1h
             

            Discussion with Niteen and control correction on HSPL copy and verification.

          niteen.surwase Niteen Surwase (Inactive) logged work - 06/May/18 11:10 PM - edited
          • Time Spent:
            3h
             

            Form Builder changes

            Checking report and Testing

          niteen.surwase Niteen Surwase (Inactive) made changes -
          Attachment WB-664 - Form Preview.JPG [ 77484 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Attachment Screenshot (227).png [ 77485 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Attachment Screenshot (227).png [ 77485 ]
          Hide
          niteen.surwase Niteen Surwase (Inactive) added a comment -

          Hi Debbie Kulling

          We have changed AFLAC Certification New --> CRITIAL ILLNESS CERTIFICATION field as per above mock-up. It worked as expected and It made no impact on any existing eligibility. 

          Please confirm at you side and let us know if you need any help.

          Thanks,

          Niteen S.

          CC; Swapnil Pandhare Satya Prashant Samal

          Show
          niteen.surwase Niteen Surwase (Inactive) added a comment - Hi Debbie Kulling We have changed  AFLAC Certification New --> CRITIAL ILLNESS CERTIFICATION field as per above mock-up. It worked as expected and It made no impact on any existing eligibility.  Please confirm at you side and let us know if you need any help. Thanks, Niteen S. CC; Swapnil Pandhare Satya Prashant Samal
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Assignee Niteen Surwase [ niteen.surwase ] Debbie Kulling [ dkulling ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status Waiting for Input [ 11502 ] In Analysis [ 10008 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status In Analysis [ 10008 ] In Development [ 10007 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status In Development [ 10007 ] LB Deployed [ 11600 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status LB Deployed [ 11600 ] In LB Testing [ 10200 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status In LB Testing [ 10200 ] Ready for Pre-Prod [ 11615 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status Ready for Pre-Prod [ 11615 ] Pre-Prod Deployed [ 11601 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status Pre-Prod Deployed [ 11601 ] IN Pre-prod Testing [ 11500 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status IN Pre-prod Testing [ 11500 ] Ready for Production [ 10024 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status Ready for Production [ 10024 ] Production Deployed [ 10025 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Status Production Deployed [ 10025 ] In Production Testing [ 10202 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Production Testing [ 10202 ] In Production Review [ 11501 ]
          Hide
          dkulling Debbie Kulling added a comment -

          I have sent this over to BCC.  I will let you know as soon as I have confirmation from them that we can close the ticket

          Show
          dkulling Debbie Kulling added a comment - I have sent this over to BCC.  I will let you know as soon as I have confirmation from them that we can close the ticket
          Hide
          dkulling Debbie Kulling added a comment -

          I have confirmed with BCC that this is working as expected.  Thank you.  I am closing this ticket.

          Show
          dkulling Debbie Kulling added a comment - I have confirmed with BCC that this is working as expected.  Thank you.  I am closing this ticket.
          dkulling Debbie Kulling made changes -
          Status In Production Review [ 11501 ] Closed [ 6 ]
          dkulling Debbie Kulling made changes -
          Status Closed [ 6 ] Temp Resolution Setting [ 11701 ]
          dkulling Debbie Kulling made changes -
          Status Temp Resolution Setting [ 11701 ] Closed [ 6 ]
          dkulling Debbie Kulling made changes -
          Status Closed [ 6 ] Temp Resolution Setting [ 11701 ]
          dkulling Debbie Kulling made changes -
          Status Temp Resolution Setting [ 11701 ] Closed [ 6 ]
          dkulling Debbie Kulling made changes -
          Resolution Done [ 10000 ] Incomplete [ 4 ]
          Status Closed [ 6 ] Temp Resolution Setting [ 11701 ]
          dkulling Debbie Kulling made changes -
          Status Temp Resolution Setting [ 11701 ] Closed [ 6 ]
          Hide
          dkulling Debbie Kulling added a comment -

          I need to reopen this ticket an it will not let me

           

          Show
          dkulling Debbie Kulling added a comment - I need to reopen this ticket an it will not let me  
          dkulling Debbie Kulling made changes -
          Status Closed [ 6 ] Temp Resolution Setting [ 11701 ]
          Hide
          dkulling Debbie Kulling added a comment -

          I apologize I closed this ticket too soon.  Can you please do the same thing you did on the Critical illness certification to the second question on the same page for Accident.  I did not realize we had the same issue with that question.

          Show
          dkulling Debbie Kulling added a comment - I apologize I closed this ticket too soon.  Can you please do the same thing you did on the Critical illness certification to the second question on the same page for Accident.  I did not realize we had the same issue with that question.
          dkulling Debbie Kulling made changes -
          Assignee Debbie Kulling [ dkulling ] Niteen Surwase [ niteen.surwase ]
          Monika.Demla Monika Demla (Inactive) made changes -
          Priority Low [ 4 ] Medium [ 3 ]
          Monika.Demla Monika Demla (Inactive) made changes -
          Labels Manual_Export
          Monika.Demla Monika Demla (Inactive) made changes -
          Labels Manual_Export Manual_Export Standard_Report
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          hi Niteen Surwase

          Please help in assisting in Opening the ticket.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - hi Niteen Surwase Please help in assisting in Opening the ticket.
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status Temp Resolution Setting [ 11701 ] Closed [ 6 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Resolution Incomplete [ 4 ] Unresolved [ 10200 ]
          Status Closed [ 6 ] In Production Review [ 11501 ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status In Production Review [ 11501 ] REOPENED IN PRODUCTION REVIEW [ 11605 ]
          Hide
          Prashant.samal Prashant Samal (Inactive) added a comment -

          Re-Opening ticket as per the request

          Monika Demla Debbie Kulling Niteen Surwase

          Show
          Prashant.samal Prashant Samal (Inactive) added a comment - Re-Opening ticket as per the request Monika Demla Debbie Kulling Niteen Surwase
          pratap.patil Pratap Patil (Inactive) made changes -
          Time Spent 5.75h [ 20700 ] 6.75h [ 24300 ]
          Worklog Id 115257 [ 115257 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Attachment WB-664 - Form Preview 2.jpg [ 77540 ]
          Hide
          niteen.surwase Niteen Surwase (Inactive) added a comment -

          Hi Debbie Kulling

          We have made changes in ACCIDENT CERTIFICATION field accordingly on County of San Luis Obispo.

          Please verify this changes and close the ticket,

          Thanks,

          Niteen S.

          CC: Swapnil Pandhare Satya Prashant Samal Monika Demla

          Show
          niteen.surwase Niteen Surwase (Inactive) added a comment - Hi  Debbie Kulling We have made changes in  ACCIDENT CERTIFICATION  field accordingly on County of San Luis Obispo. Please verify this changes and close the ticket, Thanks, Niteen S. CC: Swapnil Pandhare Satya Prashant Samal Monika Demla
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Assignee Niteen Surwase [ niteen.surwase ] Debbie Kulling [ dkulling ]
          Resolution Unresolved [ 10200 ] Done [ 10000 ]
          Status REOPENED IN PRODUCTION REVIEW [ 11605 ] In Production Review [ 11501 ]
          niteen.surwase Niteen Surwase (Inactive) logged work - 07/May/18 11:09 PM
          • Time Spent:
            1.5h
             

            Form Builder changes and Testing

          niteen.surwase Niteen Surwase (Inactive) made changes -
          Time Spent 6.75h [ 24300 ] 8.25h [ 29700 ]
          Worklog Id 115262 [ 115262 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Time Spent 8.25h [ 29700 ] 10.75h [ 38700 ]
          Worklog Id 115264 [ 115264 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Worklog Id 115264 [ 115264 ]
          Hide
          dkulling Debbie Kulling added a comment -

           BCC has verified the change.  Thank you for your help

          Show
          dkulling Debbie Kulling added a comment -  BCC has verified the change.  Thank you for your help
          dkulling Debbie Kulling made changes -
          Status In Production Review [ 11501 ] Closed [ 6 ]
          niteen.surwase Niteen Surwase (Inactive) made changes -
          Time Spent 10.75h [ 38700 ] 11.25h [ 40500 ]
          Worklog Id 115264 [ 115264 ]
          Transition Time In Source Status Execution Times
          Jyoti Agrawal (Inactive) made transition -
          Open In Development
          14d 7h 57m 1
          Swapnil Pandhare (Inactive) made transition -
          In Development Development on Hold
          6d 2h 55m 1
          Prashant Samal (Inactive) made transition -
          Development on Hold In Development
          12d 20h 49m 1
          Prashant Samal (Inactive) made transition -
          In Development In Analysis
          4s 1
          Niteen Surwase (Inactive) made transition -
          In Analysis Waiting for Input
          8h 24m 2
          Niteen Surwase (Inactive) made transition -
          Waiting for Input In Analysis
          13d 18h 33m 2
          Niteen Surwase (Inactive) made transition -
          In Analysis In Development
          21s 1
          Niteen Surwase (Inactive) made transition -
          In Development LB Deployed
          8s 1
          Niteen Surwase (Inactive) made transition -
          LB Deployed In LB Testing
          7s 1
          Niteen Surwase (Inactive) made transition -
          In LB Testing Ready for Pre-Prod
          5s 1
          Niteen Surwase (Inactive) made transition -
          Ready for Pre-Prod Pre-Prod Deployed
          10s 1
          Niteen Surwase (Inactive) made transition -
          Pre-Prod Deployed IN Pre-prod Testing
          3s 1
          Niteen Surwase (Inactive) made transition -
          IN Pre-prod Testing Ready for Production
          4s 1
          Niteen Surwase (Inactive) made transition -
          Ready for Production Production Deployed
          3s 1
          Niteen Surwase (Inactive) made transition -
          Production Deployed In Production Testing
          4s 1
          Niteen Surwase (Inactive) made transition -
          In Production Testing In Production Review
          27s 1
          Debbie Kulling made transition -
          Closed Temp Resolution Setting
          1h 17m 4
          Prashant Samal (Inactive) made transition -
          Temp Resolution Setting Closed
          9h 50m 4
          Prashant Samal (Inactive) made transition -
          Closed In Production Review
          3m 54s 1
          Prashant Samal (Inactive) made transition -
          In Production Review REOPENED IN PRODUCTION REVIEW
          13s 1
          Niteen Surwase (Inactive) made transition -
          REOPENED IN PRODUCTION REVIEW In Production Review
          1h 20m 1
          Debbie Kulling made transition -
          In Production Review Closed
          13h 42m 2

            People

            Assignee:
            dkulling Debbie Kulling
            Reporter:
            dkulling Debbie Kulling
            Account Executive:
            Debbie Kulling
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 11.25h
                11.25h