Integer Picklists on Openedge Service Objects

Posted by coates_aj on 29-May-2015 06:12

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?

Posted by Anoop Premachandran on 29-May-2015 22:41

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

Posted by pvorobie on 29-May-2015 10:58

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

Posted by coates_aj on 29-May-2015 11:04

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

Posted by pvorobie on 29-May-2015 11:08

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

Posted by coates_aj on 29-May-2015 11:24

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.

Posted by pvorobie on 29-May-2015 11:38

Let me check the problem

Posted by pvorobie on 29-May-2015 13:16

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.

Posted by Anoop Premachandran on 29-May-2015 22:41

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.

Posted by psaradhi on 01-Jun-2015 06:53
Can you please let us know the Rollbase version you are using?
 
 
[collapse]
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.

[/collapse]
Posted by Gian Torralba on 03-Jun-2015 12:03
Hello,

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

Thank you,
Gian
Posted by Pradeep Kagithalagudem on 03-Jun-2015 23:27
Hi,
 
Defect Number PSC00332456
 
The fix is available in 3.2.3 release as well.
 
Thanks and Regards
Pradeep
 
[collapse]
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.

[/collapse]
This thread is closed