Designed Query Permission

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

Table Type: System

Table Name: Designed Query Permission
Database Table Name: Designed Query Permission

Table Number: 2000000222

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 Permission can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Designed Query Permission]

Show/hide an example select of all columns by name

SELECT
   [App ID]
   ,[Role ID]
   ,[Object ID]
   ,[Read Permission]
   ,[Insert Permission]
   ,[Modify Permission]
   ,[Delete Permission]
   ,[Execute Permission]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Designed Query Permission]

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

SELECT
   *
FROM
   [Designed Query Permission] AS [Designed Query Permission]
LEFT JOIN
   [User] AS [User]
      ON
         [Designed Query Permission].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Designed Query Permission].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Designed Query Permission table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1App ID Primary Key SearchApp IDNormalGUID16App IDuniqueidentifier
2Role ID Primary Key SearchRole IDNormalCode20Role IDnvarchar(40)
3Role Name SearchRole NameFlowFieldText30
4Object ID Primary Key SearchObject IDNormalInteger4Object IDint
5Object Name SearchObject NameFlowFieldText30
6Read Permission SearchRead PermissionNormalOption4Read Permissionint
Available options are:
  • ” “
  • “Yes”
  • “Indirect”
7Insert Permission SearchInsert PermissionNormalOption4Insert Permissionint
Available options are:
  • ” “
  • “Yes”
  • “Indirect”
8Modify Permission SearchModify PermissionNormalOption4Modify Permissionint
Available options are:
  • ” “
  • “Yes”
  • “Indirect”
9Delete Permission SearchDelete PermissionNormalOption4Delete Permissionint
Available options are:
  • ” “
  • “Yes”
  • “Indirect”
10Execute Permission SearchExecute PermissionNormalOption4Execute Permissionint
Available options are:
  • ” “
  • “Yes”
  • “Indirect”
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 Permission].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [Designed Query Permission] AS [Designed Query Permission]
LEFT JOIN
       [User] AS [User]
              ON
                     [Designed Query Permission].[$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 Permission].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [Designed Query Permission] AS [Designed Query Permission]
LEFT JOIN
       [User] AS [User]
              ON
                     [Designed Query Permission].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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