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!