日期的Azure Logic App SQL ODATA筛选器 [英] Azure Logic App SQL ODATA Filter on Date

问题描述

我正在创建一个新的逻辑应用程序，该应用程序将读取一个表，其中DateCreated < ADDDAYS(-60,GETDATE())并将Archived位更新为1.

I'm creating a new Logic App that reads a table where DateCreated < ADDDAYS(-60,GETDATE()) and updates an Archived bit to 1.

但是，我一辈子都无法弄清楚如何将过滤器作为ODATA查询的一部分来实现.

However, I can't for the life of me figure out how to implement that filter as part of the ODATA query.

到目前为止，这是我正在尝试的方法: DateCreated lt addDays(utcNow(),-60)

Here's what I'm trying so far: DateCreated lt addDays(utcNow(),-60)

但是，我得到了"An unknown function with name 'utcnow' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed.\r\n inner exception: An unknown function with name 'utcnow' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed."

如何过滤文件管理器中的动态日期?

How can I filter on a dynamic date in the filer?

推荐答案

但是，我一辈子都无法弄清楚如何将过滤器作为ODATA查询的一部分来实现.

However, I can't for the life of me figure out how to implement that filter as part of the ODATA query.

我想您是说在SQL连接器上的ODATA查询上?

I suppose you mean on the ODATA Query on the SQL Connector?

您可以尝试以下方法:

DateCreated lt @ {addDays(utcNow()，-60)}

DateCreated lt @{addDays(utcNow(),-60)}

这篇关于日期的Azure Logic App SQL ODATA筛选器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！