ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

NSQL based portlet throwing error with link

book

Article ID: 213415

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

We're developing a new NSQL based portlet for an Object that has partitions assigned

When we enable the link on an Attribute field, and click one of the links, we get an error like:

[en - Unable to process request.  Server or Network error]

or a 500 error related to rights

Cause

This behavior occurs due to the NSQL query being unable to consider the rights that a Resource has to access a record based on the partition.

Since the NSQL query doesn't include the user's rights to a specific partition, it will fail when the results attempt to display in the user interface, assuming the user has no rights to the partition.

Environment

Release : 15.9.1

Component : CA PPM STUDIO

Resolution

This is a limitation of NSQL queries, as they don't include the user's partition rights when the query is performed. The results are working as expected, so using a "link" for an attribute in this scenario will not be possible.