Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How to filter the short description which contains number using servcienow api

Phanikanth
Kilo Contributor

Hi Team,

I have api which gives the SC task details and short_description.I want to filter the data using short description LIKE number(37602) and string(SHOP).Please find the attached snapshot for reference.

Example: I have short_description like below, want to filter using shop-37602.

    "Short_description" : SHOP IT Order: RSA Token -  PO: SHOP-37602

 

https://text.service-now.com/api/now/table/sc_task?sysparm_query=short_descriptionLIKEshop&sysparm_limit=2&sysparm_display_value=true&sys_created_by=talenduser.

find_real_file.png

2 REPLIES 2

Sulabh Garg
ServiceNow Employee

Hello,

In thiscase, you can build your query like this

https://text.service-now.com/api/now/table/sc_task?sysparm_query=short_descriptionLIKESHOP-37602&sysparm_limit=2&sysparm_display_value=true&sys_created_by=talenduser.

 

 

Please Mark Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

Please Mark Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

@Phanikanth - I am glad my answer helped you, Please mark it correct so that this thread can be closed and others are benefitted.

Please Mark Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg