You are viewing limited content. For full access, please sign in.

Question

Question

Workflow Query data activity- range of values

asked on October 16, 2018

In workflow Query Data activity how do I select a range of values?

For example, I have a table with date column.

In workflow I would like to select rows for range of value, lets say from 1st Oct 2018 to 15th Oct 2018.

select * from table where date >= '1 oct 2018' and date <='15 oct 2018'

or

select * from table where date between '1 oct 2018' and '15 oct 2018'

How can I achieve this?

0 0

Answer

SELECTED ANSWER
replied on October 16, 2018

Hello Maubank It ,

Yes of course.

You can simply choose 'Custom Query' Activity instead of 'Query Data' from your workflow toolbox section, and then write your desired query.

Best Regards.

2 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.