Designed Query Join

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

Table Type: System

Table Name: Designed Query Join
Database Table Name: Designed Query Join

Table Number: 2000000220

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Designed Query Join]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Query ID]
   ,[Inner Data Item]
   ,[Order]
   ,[Inner Field]
   ,[Outer Data Item]
   ,[Outer Field]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Designed Query Join]

Show/hide columns in Designed Query Join table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Query ID Primary Key Searchbigint
3Inner Data Item Primary Key Searchnvarchar(240)
4Order Primary Key Searchint
5Inner Field Searchnvarchar(60)
6Outer Data Item Searchnvarchar(240)
7Outer Field Searchnvarchar(60)
8$systemId Searchuniqueidentifier
9$systemCreatedAt Searchdatetime
10$systemCreatedBy Searchuniqueidentifier
11$systemModifiedAt Searchdatetime
12$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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