Designed Query Order By

Table Type: System

Table Name: Designed Query Order By
Database Table Name: Designed Query Order By

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [Designed Query Order By]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Query ID]
   ,[Order]
   ,[Column]
   ,[Direction]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [Designed Query Order By]

Show/hide columns in Designed Query Order By table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Query ID	bigint
3	Order	int
4	Column	nvarchar(240)
5	Direction	int
6	$systemId	uniqueidentifier
7	$systemCreatedAt	datetime
8	$systemCreatedBy	uniqueidentifier
9	$systemModifiedAt	datetime
10	$systemModifiedBy	uniqueidentifier