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.
1. Create simple NSQL as below
SELECT @SELECT:DIM:USER_DEF:IMPLIED:BRP:BRP.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
Release : 15.8.1
Component : CA PPM STUDIO
Defect DE56329, Under review by Engineering.
Workaround: Convert number to character in the NSQL query