Auto Suggest Not Working On Custom Object Attribute Dynamic Query Lookup

book

Article ID: 8917

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Auto Suggest does not work for a custom attribute under a custom object, which is using a dynamic query based lookup.

Steps to reproduce: 

1. Create a custom object based on the master project object.

2. Provide the dynamic query.

Example:

select name,code from INV_INVESTMENTS
where odf_object_code = 'application'

3. Click Save and Continue.

Expected Result: Autosuggest should work.

Actual Result: Autosuggest does not work.

Cause

The query will need to be rewritten in NSQL format.

Resolution

The rewritten query is:

SELECT
@SELECT:inv.name:[email protected],
@SELECT:inv.code:[email protected]
from INV_INVESTMENTS inv
WHERE @[email protected]