Database view which shows the change request which have planned start date is 4 days from today

jitendrag
Tera Expert

‎10-03-2023 06:58 AM

I have created a database view to export the data to mid server.I have used the below tables.

Outages

Change request 

Cmdb_ci

 

In this database i want to only show the change requests which have planned start date 4days from Today

 

Can any one help me how to achieve this??

 

Thanks in advance

0 Helpfuls
  • 236 Views
1 REPLY 1

jitendrag
Tera Expert
In response to nowgpt1

‎10-03-2023 07:12 AM - edited ‎10-03-2023 07:14 AM

I need to export the data everyday and which Today date you mentioned will change. How to achieve the dynamic date in where clause??

Can i use this code gs.beginningOfToday() + 4*24*60*60*1000.

 

0 Helpfuls