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
   [timestamp]
   ,[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 columns in Designed Query Column Filter table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Query ID Primary Key Searchbigint
3Column Primary Key Searchnvarchar(240)
4Order Primary Key Searchint
5Filter Type Searchint
6Value Searchnvarchar(4096)
7Ignore Case Searchtinyint
8Filter Expression Type Searchint
9Operand Count Searchint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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