Generic Chart Filter

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

Table Type: Company

Table Name: Generic Chart Filter
Database Table Name: CRONUS UK Ltd_$Generic Chart Filter$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 9181

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Generic Chart Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Line No_]
   ,[Filter Field ID]
   ,[Filter Field Name]
   ,[Filter Value]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Generic Chart Filter$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Generic Chart Filter table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Filter Field ID Searchint
5Filter Field Name Searchnvarchar(60)
6Filter Value Searchnvarchar(500)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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