查询实体记录

根据指定筛选器，从 UiPath Data Fabric 中检索所选实体的记录列表。

描述

根据指定筛选器，从 UiPath Data Fabric 中检索所选实体的记录列表。

此活动等效于 Data Service 传统活动包中的同名活动。

项目兼容性

Windows | 跨平台

支持的工作流

除 RPA 以外的所有工作流（Studio Desktop 或 Studio Web）。

属性

• UiPath Data Fabric 连接- 选择您在 Integration Service 中建立的 Data Fabric 连接。访问下拉菜单，以选择、添加或管理连接。
• “实体” - 选择要与此活动一起使用的实体。此下拉菜单包含 Data Fabric 实体。根据在此字段中选择的对象，系统将使用该对象的特定属性字段填充活动。此字段支持TypeArgument类型的输入。 ImportedEntities
  • 如果您切换到对象视图，则必须提供单个整合对象，其中包含每个字段的值。
• 查询- 使用筛选条件构建器添加查询以筛选实体记录

The Filter Builder provides a set of operators that you can use to filter records based on the values of entity fields. The operators available for a field depend on its data type.

The following table describes each supported operator and the data types it applies to.

For the In and Not In operators, enter values as a comma-separated list. For example, to return only records where the text field productName in the Product entity is Computer or Laptop, enter Computer,Laptop.

运算符	描述	Applicable data types
Equals (=)	Matches records where the field value is exactly equal to the specified value.	Text, Number, Yes/No, Date-Time, ChoiceSet
Not Equals (!=)	Matches records where the field value is not equal to the specified value.	Text, Number, Yes/No, Date-Time, ChoiceSet
Less Than (<)	Matches records where the field value is less than the specified value. For date fields, this returns records with an earlier date or time.	Number, Date-Time
Less Than Or Equal (<=)	Matches records where the field value is less than or equal to the specified value.	Number, Date-Time
Greater Than (>)	Matches records where the field value is greater than the specified value. For date fields, this returns records with a later date or time.	Number, Date-Time
Greater Than Or Equal (>=)	Matches records where the field value is greater than or equal to the specified value.	Number, Date-Time
包含	Matches records where the field value contains the specified text as a substring.	文本
不包含	Matches records where the field value does not contain the specified text.	文本
开头为	Matches records where the field value begins with the specified text.	文本
结尾为	Matches records where the field value ends with the specified text.	文本
输入	Matches records where the field value is equal to any value in a specified list.	Text, Number, Date-Time, ChoiceSet
Not In	Matches records where the field value is not equal to any value in the specified list.	Text, Number, Date-Time, ChoiceSet
Is Null	Matches records where the field value is null. This operator does not require an input value.	Text, Number, Yes/No, Date-Time, ChoiceSet
Is Not Null	Matches records where the field contains a non-null value. This operator does not require an input value.	Text, Number, Yes/No, Date-Time, ChoiceSet
Is True	Matches records where a Yes/No field is True. This operator does not require an input value.	是/否
Is False	Matches records where a Yes/No field is False. This operator does not require an input value.	是/否

选项

• 跳过- 指定从开头开始跳过的记录数。
• 置顶- 指定最多要返回的记录数。属性支持从 1 到 1000 的值。默认值为 100。
• 升序排序- 指定是按升序 (true) 还是降序 (false) 排序。
• 按字段排序- 指定用于对返回的记录进行排序的字段。
• 相关记录深度- 指定服务响应中相关记录的深度。范围：1-3。默认值：3。

输出

• 查询实体记录—返回所选实体中与所提供筛选条件匹配的记录列表。每条记录都包含调用者有权访问的所有字段。