Designed Query Column Filter

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

Table Type: System

Table Name: Designed Query Column Filter
Database Table Name: Designed Query Column Filter

Table Number: 2000000217

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Designed Query Column Filter]

Show/hide an example select of all columns by name

SELECT
   [Query ID]
   ,[Column]
   ,[Order]
   ,[Filter Type]
   ,[Value]
   ,[Ignore Case]
   ,[Filter Expression Type]
   ,[Operand Count]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Designed Query Column Filter]

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

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

Show/hide columns in Designed Query Column Filter table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Query ID Primary Key SearchQuery IDNormalBigInteger8Query IDbigint
2Column Primary Key SearchColumnNormalText120Columnnvarchar(240)
3Order Primary Key SearchOrderNormalInteger4Orderint
4Filter Type SearchFilter TypeNormalOption4Filter Typeint
Available options are:
  • “Equal”
  • “NotEqual”
  • “GreaterThan”
  • “GreaterThanEqual”
  • “LessThan”
  • “LessThanEqual”
  • “Contains”
5Value SearchValueNormalText2048Valuenvarchar(4096)
6Ignore Case SearchIgnore CaseNormalBoolean4Ignore Casetinyint
7Filter Expression Type SearchFilter Expression TypeNormalOption4Filter Expression Typeint
Available options are:
  • “Filter”
  • “Logical”
8Operand Count SearchOperand CountNormalInteger4Operand Countint
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 Column Filter].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [Designed Query Column Filter] AS [Designed Query Column Filter]
LEFT JOIN
       [User] AS [User]
              ON
                     [Designed Query Column Filter].[$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 Column Filter].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [Designed Query Column Filter] AS [Designed Query Column Filter]
LEFT JOIN
       [User] AS [User]
              ON
                     [Designed Query Column Filter].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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