Get details of the individual that uses the application.

Select

The adapter will use the API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.

• Id supports the '=,IN,>=,<=,>,<' operators.
• CurrentSignInAt supports the '=,>=,<=,>,<' operators.
• CreatedAt supports the '=,>=,<=,>,<' operators.
• Email supports the '=,IN' operators.
• FirstName supports the '=,IN' operators.
• LastName supports the '=,IN' operators.
• UpdatedAt supports the '=,>=,<=,>,<' operators.
• UserName supports the '=,IN' operators.
• ContentCategoryMembershipsId supports the '=' operator.
• MailboxId supports the '=' operator.
• RecipientsId supports the '=' operator.
• ProfileId supports the '=' operator.
• RoleId supports the '=' operator.
• TeamsId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM UsersDuties WHERE Id = 1

SELECT * FROM UsersDuties WHERE Id IN (1,2)

SELECT * FROM UsersDuties WHERE Id >= 1

SELECT * FROM UsersDuties WHERE Id <= 1

SELECT * FROM UsersDuties WHERE Id > 1

SELECT * FROM UsersDuties WHERE Id < 2

SELECT * FROM UsersDuties WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND createdAt <= '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE CurrentSignInAt = '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE UpdatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM UsersDuties WHERE Email = 'test@gmail.com'

SELECT * FROM UsersDuties WHERE FirstName = 'test'

SELECT * FROM UsersDuties WHERE LasttName = 'test'

SELECT * FROM UsersDuties WHERE ContentCategoryMembershipsId = 1

SELECT * FROM UsersDuties WHERE MailboxId = 1

SELECT * FROM UsersDuties WHERE ProfileId = 1

SELECT * FROM UsersDuties WHERE RecipientsId = 1

SELECT * FROM UsersDuties WHERE TemplateId = 1

SELECT * FROM UsersDuties WHERE RoleId = 1

SELECT * FROM UsersDuties WHERE TeamsId = 1

Columns

Name	Type	Description
Id [KEY]	Integer	Id.
Name	String	Duty name.
DutyType	String	Duty type.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
UsersId	Integer	Id of Users.
CreatedAt	Datetime	The date and time the user was created.
CurrentSignInAt	Datetime	The date and time the user most recently signed in.
Email	String	The email address of the user.
FirstName	String	The first name of the user.
LastName	String	The last name of the user.
Locked	Boolean	A boolean value indicating whether or not the user is locked out of the application.
UpdatedAt	Datetime	The globally unique ID GUID assigned to the user.
Username	String	A reader friendly unique identifier of the user.
MailboxId	Integer	Mailboxes Id associated with the users.
ProfileId	Integer	Profile Id associated with the users.
RecipientsId	Integer	Recipients Id associated with the users.
RoleId	Integer	Roles Id associated with the users.
TeamsId	Integer	Teams Id associated with the users.
UpdaterId	Integer	The Updater Id of the template.