Integer Picklists on Openedge Service Objects - Forum - Rollbase - Progress Community

Integer Picklists on Openedge Service Objects

 Forum

Integer Picklists on Openedge Service Objects

This question is answered

We are using Rollbase 3.2.0.0 and I have an Openedge Service object that I have imported into Rollbase where one of the fields is an integer field.

For this particular field I would like to display descriptions instead of the integer value, so I have converted this field to the datatype "Picklist (int)". I have also entered the following into the Values text box:

Weakest|0
Weak|1
Moderate|2
Strong|3
Strongest|4

The problem I have is that even though my underlying openedge record has the value of 2, the values are never displayed on the list and view screens. Additionally when editing the record the drop-down has all these entries but always defaults back to " -- Please select -- ".

Is there something else I need to do or need to set up?

Verified Answer
  • There was an issue with retrieving integer and displaying pick-list with OpenEdge Service Objects. This is fixed in main branch (4.0 release). Tentative time-frame for 4.0 release is August.

All Replies
  • What happens when you create a new record? Can you save picklist's value successfully?

  • Hi,

    When I create a new record and choose "strongest", then the underlying openEdge record has the correct value of 4 assigned, but it is never  displayed properly within Rollbase.

    Thanks

  • Could you check OpenEdge communication log file? Link (button) can be found on Object View page.

  • This is the output from all my recent reads:

    [2015-05-29 17:13:13,978] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

    [2015-05-29 17:13:14,853] Customer Settings: Response: Chars: 494, a132: 1

    [2015-05-29 17:13:18,605] Customer Settings: Filter: CustomerSettingId=1

    [2015-05-29 17:13:18,606] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting?filter=CustomerSettingId%3D1

    [2015-05-29 17:13:19,473] Customer Settings: Response: Chars: 494, a132: 1

    [2015-05-29 17:13:19,494] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

    [2015-05-29 17:13:20,356] Customer Settings: Response: Chars: 494, a132: 1

    [2015-05-29 17:14:42,152] User Account: Filter: {"ablFilter":"(LoginName<>'') AND (LoginName<>?)"}

    [2015-05-29 17:14:42,153] http://localhost:8810/hrpo/rest/hrpoService/siPerson?filter=%7B%22ablFilter%22%3A%22%28LoginName%3C%3E%27%27%29+AND+%28LoginName%3C%3E%3F%29%22%7D

    [2015-05-29 17:14:53,203] User Account: Filter: {"ablFilter":"(LoginName<>'') AND (LoginName<>?)"}

    [2015-05-29 17:14:53,204] http://localhost:8810/hrpo/rest/hrpoService/siPerson?filter=%7B%22ablFilter%22%3A%22%28LoginName%3C%3E%27%27%29+AND+%28LoginName%3C%3E%3F%29%22%7D

    [2015-05-29 17:14:57,515] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

    [2015-05-29 17:14:57,610] Customer Settings: Response: Chars: 494, a132: 1

    [2015-05-29 17:15:01,987] Customer Settings: Filter: CustomerSettingId=1

    [2015-05-29 17:15:01,988] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting?filter=CustomerSettingId%3D1

    [2015-05-29 17:15:02,100] Customer Settings: Response: Chars: 494, a132: 1

    [2015-05-29 17:15:02,119] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

    [2015-05-29 17:15:02,220] Customer Settings: Response: Chars: 494, a132: 1

    [2015-05-29 17:15:04,358] User Account: Response: Chars: 11375, a132: 13

    [2015-05-29 17:15:21,738] Customer Settings: Filter: CustomerSettingId=1

    [2015-05-29 17:15:21,739] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting?filter=CustomerSettingId%3D1

    [2015-05-29 17:15:22,606] Customer Settings: Response: Chars: 494, a132: 1

    [2015-05-29 17:15:49,451] Customer Settings: Filter: CustomerSettingId=1

    [2015-05-29 17:15:49,452] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting?filter=CustomerSettingId%3D1

    [2015-05-29 17:15:50,324] Customer Settings: Response: Chars: 494, a132: 1

    [2015-05-29 17:15:50,343] http://localhost:8810/hrpo/rest/hrpoService/siCustomerSetting

    [2015-05-29 17:15:51,217] Customer Settings: Response: Chars: 494, a132: 1

    However, there  was an error raised when doing my initial create:

    [2015-05-29 17:00:53,835] Communication error:{"_errors":[{"_errorMsg":"ERROR condition: Framework Error: 1002,Unable to instantiate class com.sage.hrpo.be.beCustomerTenant.,, (SG20) (7211)","_errorNum":20}]}

    I'll correct that problem and see if it helps, although I'm not sure it would explain why the existing records aren't displaying correctly.

  • Let me check the problem

  • I cannot reproduce the problem: Picklist (int) field can be displayed and updated without problems.

    Please check log generated when record is updated. You should see something like this:

    [2015-05-29 11:09:49,737] Update ttItem: request

    {"dsItem":{"ttItem":[{"Special": "1", "Category2": "Equipment", "OnOrder": 479, "Itemnum": 7, "Weight": 8.00, "Category1": "Diving", "Price": 125.00, "ItemName": "Buoyancy Vest", "CatDescription": "Stay afloat with your own helium buoyancy vest.", "seq": 1, "Minqty": 30, "Allocated": 10876, "Onhand": 12877, "ReOrder": 15, "CatPage": 6}]}}

    [2015-05-29 11:09:50,231] Update ttItem: response

    {"dsItem":{"ttItem":[{"Allocated":10876,"CatDescription":"Stay afloat with your own helium buoyancy vest.","Category1":"Diving","Category2":"Equipment","CatPage":6,"ItemName":"Buoyancy Vest","Itemnum":7,"Minqty":30,"Onhand":12877,"OnOrder":479,"Price":125.0,"ReOrder":15,"Special":"1","Weight":8.0,"id":"","seq":1}]}}

    Please note value for "CatPage" field which was set to 6 in my test. On View/edit page I see option "Six".

    Also, when you expand picklist field, do you see all choices beneath "Please select" prompt? Just to make sure that your configuration was saved successfully.

    Finally, it always helpful to know whether problem remains after Rollbase server restart.

  • There was an issue with retrieving integer and displaying pick-list with OpenEdge Service Objects. This is fixed in main branch (4.0 release). Tentative time-frame for 4.0 release is August.

  • Can you please let us know the Rollbase version you are using?
     
     
    From: pvorobie [mailto:bounce-pvorobie@community.progress.com]
    Sent: 29 May 2015 23:47
    To: TU.Rollbase@community.progress.com
    Subject: RE: [Technical Users - Rollbase] Integer Picklists on Openedge Service Objects
     
    Reply by pvorobie

    I cannot reproduce the problem: Picklist (int) field can be displayed and updated without problems.

    Please check log generated when record is updated. You should see something like this:

    [2015-05-29 11:09:49,737] Update ttItem: request

    {"dsItem":{"ttItem":[{"Special": "1", "Category2": "Equipment", "OnOrder": 479, "Itemnum": 7, "Weight": 8.00, "Category1": "Diving", "Price": 125.00, "ItemName": "Buoyancy Vest", "CatDescription": "Stay afloat with your own helium buoyancy vest.", "seq": 1, "Minqty": 30, "Allocated": 10876, "Onhand": 12877, "ReOrder": 15, "CatPage": 6}]}}

    [2015-05-29 11:09:50,231] Update ttItem: response

    {"dsItem":{"ttItem":[{"Allocated":10876,"CatDescription":"Stay afloat with your own helium buoyancy vest.","Category1":"Diving","Category2":"Equipment","CatPage":6,"ItemName":"Buoyancy Vest","Itemnum":7,"Minqty":30,"Onhand":12877,"OnOrder":479,"Price":125.0,"ReOrder":15,"Special":"1","Weight":8.0,"id":"","seq":1}]}}

    Please note value for "CatPage" field which was set to 6 in my test. On View/edit page I see option "Six".

    Also, when you expand picklist field, do you see all choices beneath "Please select" prompt? Just to make sure that your configuration was saved successfully.

    Finally, it always helpful to know whether problem remains after Rollbase server restart.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

  • Hello,

    What is the defect number for this issue for tracking purposes?

    Thank you,
    Gian
  • Hi,
     
    Defect Number PSC00332456
     
    The fix is available in 3.2.3 release as well.
     
    Thanks and Regards
    Pradeep
     
    From: Gian Torralba [mailto:bounce-gtorralb@community.progress.com]
    Sent: Wednesday, June 03, 2015 10:34 PM
    To: TU.Rollbase@community.progress.com
    Subject: RE: [Technical Users - Rollbase] Integer Picklists on Openedge Service Objects
     
    Reply by Gian Torralba
    Hello,

    What is the defect number for this issue for tracking purposes?

    Thank you,
    Gian
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.