The CreatorCon Call for Content is officially open! Get started 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
Mega Sage

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