How To Filter Using String in NSQL

Products

• Clarity PPM On Premise

Issue/Introduction

Is there a way to keep down the NSQL result set?
Can an example be provided?

 

Resolution

There is an NSQL documentation that mentions how to use the filter and it would just be used as normal SQL.

NSQL Usage

The NSQL filter condition can use the keyword(like) as in the following example:

SELECT   @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:R.UNIQUE_NAME:[email protected]
FROM     
         SRM_RESOURCES R
WHERE  1=1  
AND      @[email protected]
and r.UNIQUE_NAME like '%test_string_here%'