To view the users details.

Table Specific Information

Select

The add-in 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 add-in.

• 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