To view the users details.

Table Specific Information

Select

The connector will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

• Id supports the '=' comparison.
• WorkspaceId supports the '=' comparison.
• TeamId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = '1126938691750986'

SELECT * FROM Users WHERE WorkspaceId = '1126938837961835'

SELECT * FROM Users WHERE TeamId = '1129514033997892'

In case of UseTypeaheadSearch property set to true, only Name and WorkspaceId columns would be filterable server side with Name supporting '=, LIKE' comparison when LIKE used only in the following ways:

SELECT * FROM Users WHERE Name = 'abc'

SELECT * FROM Users WHERE Name LIKE 'abc'

SELECT * FROM Users WHERE Name LIKE 'abc%'

SELECT * FROM Users WHERE Name LIKE 'abc%' AND WorkspaceId = '1126938837961830'

Columns