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

Document ID : KB000008917
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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 an object as Partenaire(ID: inca_prtenaire) 

2. Create a Static lookup as AC Catégorie (ID: INCA_AC_CAT) 

3. Add two values in the lookup. 

4. Create a custom attribute in the "Partenaire" object as Catégorie (ID: inca_categorie) 

5. Create a Dynamic Query based lookup as partenairecode (ID: partenairecode) 

6. Query used in that Lookup: 

select nPAR.* 

from ( 

SELECT par.ID 

, (par.name || ' - ' || par.CODE ) part 

, par.CODE, par.name partenaire 

, par.inca_categorie cat_code 

, par.last_updated_date maj_le 

FROM ODF_CA_INCA_PRTENAIRE par 

) nPAR 

WHERE @FILTER@ 

7. Create another custom attribute under "Partenaire" object as testcode (ID: testcode) 

8. Added the "testcode" attribute in the "Partenaire Filter" view. 

9. Created a Partenaire object instance. 

10. Expand the filter section and see if the autosuggestion works for the Testcode filter field.

Expected Result: Auto Suggest in Testcode filter field should work.

Actual Result: Auto Suggest in Testcode filter field does not work.

Environment:
CA PPM 14.3
Cause:

Due to defect DE28426 or CLRT-79624.

Resolution:

If the query is re-written as: 

select @SELECT:nPAR.id:id@ 

       , @SELECT:nPAR.part:part@ 

       , @SELECT:nPAR.code:code@ 

       , @SELECT:nPAR.cat_code:cat_code@ 

       , @SELECT:nPAR.maj_le:maj_le@ 

from ( 

SELECT par.ID 

, (par.name || ' - ' || par.CODE ) part 

, par.CODE, par.name partenaire 

, par.inca_categorie cat_code 

, par.last_updated_date maj_le 

FROM ODF_CA_INCA_PRTENAIRE par 

) nPAR 

WHERE @FILTER@ 

 

Then the auto-suggest should work and the filter will work as well.