Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Time sheets list view based on custom query

Kumar122
Tera Contributor

Hello,

 

I want to run a script on “time_sheet” table and display all time sheets, only when a time card category is not PTO, not Holiday.

 

If a timesheet has the following:

 

Case#1:

  • Time card1 PTO
  • Time card2 Incident123
  • Time card3 Holiday

Result: Display this time sheet

 

 

Case#2:

  • Time Card1 Holiday
  • Time card2 PTO

Result: Don’t display this card sheet

 

Case#3:

  • Time card1 Incident 234
  • Time card2 Incident 456
  • Time card3 Incident 678

Result: Display this time sheet

 

I want to run this script to show records in a “list” view

 

Appreciate any help. Thank you!

 

Regards

Kumar

1 REPLY 1

Kumar122
Tera Contributor

Appreciate any help on this one. Thank you!