cancel
Showing results for 
Search instead for 
Did you mean: 

To extract the data for last 30 days via SQL query in redwood filter

Gabie
Explorer
0 Kudos

Hello Experts,

Need help in the below query to extract the data for last 30 days from current date in redwood using SQL 92.

The below query is not working. kindly help.

Select * from JobDefinition jd,JobChain jc where jd.BranchedLLPVersion = -1 and jc.JobDefiniton = jd.UniqueId and jc.LastModificationTime >now()-30

Thanks

Gabie

gmblom
Active Contributor
0 Kudos

Hello,

try now('subtract 30 days')

Regards Gerben

0 Kudos

Hello Gerben,

i tested below SQL with your advise but its throwing below error:

select * from JobDefinition jd where jd.BranchedLLPVersion = -1 and jd.LastModificationTime > now('extract 30 days')

Invalid operator extract in expression

gmblom
Active Contributor
0 Kudos

Sorry, I put in the wrong expression. I have update my original comment with the correct one.

Gabie
Explorer
0 Kudos

Thanks Gerben.

The query works fine in the report definition filter but the same query does not work in the process filter.

Actually for creating a dashboard we only have an option of calling a filter and not the report definition.

Accepted Solutions (0)

Answers (0)