AnsweredAssumed Answered

Browse-Only Construct Not Effective with nested statements???

Question asked by marlon.mckenzie on Apr 26, 2011
Latest reply on Apr 27, 2011 by Dave
Hello All,

I am attempting to use the browse-only construct but it doesn't seem to be working.

Following query is being used to feed a dynamic lookup and when a value is selected and saved, it is disappearing from the field (im guessing because that value no longer meets the conditions).

Shouldn't the browse-only construct prevent this? Can browse-only be used on nested queries?

Snippet:
SELECT @SELECT:P.ID:ID@,
@SELECT:P.UNIQUE_NAME:UNIQUE_CODE@

FROM SRM_PROJECTS P

WHERE @FILTER@
@BROWSE-ONLY:
AND P.ID NOT IN (SELECT CS_PRT_PREDECESSOR
FROM ODF_CA_PROJECTS
WHERE CS_PRT_PREDECESSOR IS NOT NULL)
:BROWSE-ONLY@

Any help would be appreciated.

Thanks,
Marlon

Outcomes