Designed Query Category

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000215

Table Type: System

Table Name: Designed Query Category
Database Table Name: Designed Query Category

Table Number: 2000000215

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Designed Query Category can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Designed Query Category]

Show/hide an example select of all columns by name

SELECT
   [Query ID]
   ,[Order]
   ,[Category]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Designed Query Category]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [Designed Query Category] AS [Designed Query Category]
LEFT JOIN
   [CRONUS UK Ltd_$Workflow Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Category]
      ON
         [Designed Query Category].[Category] = [Workflow Category].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Designed Query Category].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Designed Query Category].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Designed Query Category table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Query ID Primary Key SearchQuery IDNormalBigInteger8Query IDbigint
2Order Primary Key SearchOrderNormalInteger4Orderint
3Category SearchCategoryNormalText30Categorynvarchar(60)
Key to join to the Workflow Category table.

Show/hide example query

SELECT
       [Designed Query Category].[Category]
       ,[Workflow Category].[Code]
FROM
       [Designed Query Category] AS [Designed Query Category]
LEFT JOIN
       [CRONUS UK Ltd_$Workflow Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Category]
              ON
                     [Designed Query Category].[Category] = [Workflow Category].[Code]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Designed Query Category].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [Designed Query Category] AS [Designed Query Category]
LEFT JOIN
       [User] AS [User]
              ON
                     [Designed Query Category].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Designed Query Category].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [Designed Query Category] AS [Designed Query Category]
LEFT JOIN
       [User] AS [User]
              ON
                     [Designed Query Category].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

Your email address will not be published. Required fields are marked *