NSQL Based Portlet 'Show Separator option' on Fields is not working as expected

book

Article ID: 195002

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

I have Number data type field in portlet and have disabled the show separator option on field configuration. The portlet is still displaying the thousand separator in the results. I have published the portlet and portlet page also to reflect the changes.
Please advise. 

Cause

1. Create simple NSQL as below
SELECT   @SELECT:DIM:USER_DEF:IMPLIED:BRP:BRP.ID:[email protected],
         @SELECT:DIM_PROP:USER_DEF:IMPLIED:BRP:BRP.PROCESS_VERSION_ID:[email protected]
FROM     BPM_RUN_PROCESSES BRP
WHERE @[email protected]
2. Create portlet based on the NSQL created in step 1
3. Under List Column Section go to Fields and click on properties for "process_run_id" and uncheck Show Separator flag, click Save.
4. Place portlet anywhere to be able to view the data and notice that Show Separator settings is not taking affect for "process_run_id" attribute.

Expected Results: You should not see separator

Actual Results: You still see separator

Environment

Release : 15.8.1

Component : CA PPM STUDIO

Resolution

Defect DE56329, Under review by Engineering.

Workaround: Convert number to character in the NSQL query