Distinct list values in catalog variable?

[gmbroth]

Hi,

I have a Lookup Select Box catalog variable bound to a table and column where some rows have the same column value; I'd like my selection list to present distinct column values only (and not show duplicate values as it does now). I attempted to define a business rule in which I intended to use GlideAggregate to produce distinct values but it doesn't affect my selection list; I set it to trigger on display (and also tried Query) but am not sure how to connect the results to my catalog item. I also thought about defining a database view on the table, perhaps using some kind of self-join, to produce unique column values. Ideally, I'd like the server-side to produce distinct values that the catalog variable will simply render. I'm aware there are differences with forms versus catalog items; what's the right approach here for a selection list catalog item?

SN Version: Berlin

Thanks, Garry

[domaners · Accepted solution]

Hi Garry, there is a field called "Unique values only", however unfortunately I think you'll need to upgrade to Calgary or Dublin for this, I'm not quite sure which.

Using Service Catalog Variables - ServiceNow Wiki

[Kalaiarasan Pus]

Tried using reference qualifier for this?