How to filter unique reocrds in a table??

[Jitu Kumar]

Hi,

I have a custom table name "Contractual". Which has Home field which is a reference field of a other table denomination whose fields are Name , Role, Country. 

I want to get unique value of name should be visible when I click home button on Contractual table.

Can anyone suggest which filter condition shall I mention to get these requirement or do I need to write script for this. If yes, what and where? 

[SumanthDosapati]

Hi,

This thread might help you

https://community.servicenow.com/community?id=community_question&sys_id=aaf00ba5db98dbc01dcaf3231f96...

Mark as correct or helpful if it does.

Regards,

Sumanth

[Jitu Kumar]

Hi,

I have used this scripted filter and is working fine in background script. But when I am putting it in script include and calling it in reference qualifier condition it is not working as expected.

Can you please help where I am calling the script include correctly or not???

[SumanthDosapati]

Hi,

No! Actually you are passing a parameter to duplicateVal1 function in reference qualifier but in script include duplicateVal1 is not having any arguments receiving.

Make sure you write your reference qualifier and script include correct.

Regards,

Sumanth

[Jitu Kumar]

Hi,

Shall I remove parameter from duplicateVal1 function in reference qualifier, because I am not passing any parameter in Script include duplicateVal1 function.

Still not working even After removing the argument from both places.