Using Javascript in sysparm_query

[Abdullah12]

I have a requirement that I have use script in sysparm_query in Attachment API. But It is not working as expected(means not returning the correct results).

The script include used. In background script it is working fine

[palanikumar]

You can't pass the JavaScript this way. Instead create a database view and add your filter condition in the database view. You can call the database view from API.

Otherwise, create a Scripted Rest API and add all your filter within the script.

Thank you,

Palani 

[Abdullah12 · Accepted solution]

As for other people , I want to share this:

Using Javascript in sysparm_query is possible if your script include is client callable and have same function name as the script include.

You can use javascript as follows:

Results of query:

For more information checkout this product documentation regarding scripted Filters :

https://docs.servicenow.com/bundle/washingtondc-platform-user-interface/page/use/using-lists/task/t_...