Skip to main content

Query

Description

On this page you will find how to create an action of the type Team based in Data Source.

Specifies which Users to show in each Team.

Includes Department and Typology.

Placed as Data Source in the Team.

Basic Usage

Available filters

ParameterTypeRequiredDescription
@AssignmentTypeldUniqueidentifierfalse Id of the assignment type
@DocumentOidUniqueidentifierfalse Id of the document
@DocumentTypeNameStringfalseName of the document type
@SearchValuestringfalseSearch value

Required fields for Query

  • UserId
  • UserName
  • Name
  • UserHasImage
  • TypologyName
  • DepartmentName
select u.Oid as UserId,
u.Name as Username,
u.[Name] as [Name],
u.HasImage as UserhasImage,
uty.Name as TypologyName,
dep.Name as DepartmentName
from [User] u
left join UserTypology uty on u.Typology = uty. [0id]
left join Department dep on .Department = dep. [Oid]
where u.[Name] like concat('%', @SearchValue, '%') or @SearchValue = ''
order bY u.[Name]

img-box-shadow