Reference qualifier on CI in Record Producer

[Pratiksha KC]

We wants to achieve reference qualifier for configuration Item variable based on two conditions: 

1. if category selected as software it should show the records from table - cmdb_ci_service_discovered and cmdb_ci_service_auto. 

(For this we have wrote advance qualifier , it is working fine -
javascript:current.variables.category=='software' ? 'sys_class_name=cmdb_ci_service_discovered^ORsys_class_name=cmdb_ci_service_auto' : '' ) 

2. The field CI on the RRP should only show records from Primary classes.

In backend, on incident we have reference qualifier For CI - javascript: ['incident', 'problem'].indexOf(current.sys_class_name + '') == -1? '' : 'operational_statusNOT IN' + new OpsStatusFilter('cmdb_ci').by('CreateTask').join()

How can we achieve this?

[Pratiksha KC]

@Ankur Bawiskar 

Tried using this way. 

But it still shows duplicate values

[Ankur Bawiskar]

@Pratiksha KC 

how are you knowing it's duplicate?

why same CI name is there in cmdb_ci table?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Pratiksha KC]

@Ankur Bawiskar 

They have different versions of CI's 

[Ankur Bawiskar]

@Pratiksha KC 

what do you mean by different versions of CIs?

are those separate records i.e. with separate sysIds?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Pratiksha KC]

@Ankur Bawiskar 

Yes, they have diff sys_id