Skip to main content

Hi Team,

 

i have a job that run's everyday, i want to filter the array objects and extract the records that were modified, created in last 24hrs. i want to check all these 4 fields "C_Created_Date", "C_Updated_Date", "A_Created_Date" ,"A_Updated_Date".

 

If any one of these date fall under last 24hrs, i want to filter those records. Can you please assist.

 

input:

[

{

"Id": 212449,

"C_Created_Date": "2018-08-08 21:24:53.284",

"C_Updated_Date": "2023-10-31 15:34:38.926",

"A_Created_Date": "2018-08-08 21:13:13.809",

"A_Updated_Date": ""

},

{

"Id": 212439,

"C_Created_Date": "2018-08-08 22:27:47.442",

"C_Updated_Date": "2023-02-07 14:44:04.138",

"A_Created_Date": "2018-08-08 22:27:42.146",

"A_Updated_Date": "2023-10-31 17:34:12.853"

},

{

"Id": 21234449,

"C_Created_Date": "2018-08-08 22:30:21.739",

"C_Updated_Date": "2023-02-07 14:44:04.138",

"A_Created_Date": "2018-08-08 22:30:16.766",

"A_Updated_Date": ""

},

{

"Id": 423233,

"C_Created_Date": "2018-08-10 17:51:11.862",

"C_Updated_Date": "2023-02-07 14:44:04.138",

"A_Created_Date": "2018-08-10 17:51:07.438",

"A_Updated_Date": ""

},

{

"Id": 56462148,

"C_Created_Date": "2018-09-13 20:58:37.459",

"C_Updated_Date": "2023-02-07 14:44:04.138",

"A_Created_Date": "2018-09-13 20:57:09.180",

"A_Updated_Date": ""

},

{

"Id": 112324,

"C_Created_Date": "2018-09-21 20:43:37.095",

"C_Updated_Date": "2023-02-07 14:44:04.138",

"A_Created_Date": "2018-09-21 20:42:20.070",

"A_Updated_Date": ""

}

]

#DataWeave 2​ 

3 risposte
0/9000