Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2028
Table Type: Company
Table Name: MS – Image Analyzer Tags
Database Table Name: CRONUS UK Ltd_$MS – Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04
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 MS – Image Analyzer Tags can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04]Show/hide an example select of all columns by name
SELECT
FROM
[CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags]
LEFT JOIN
[CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
ON
[MS - Image Analyzer Tags].[Item Category Code] = [Item Category].[Code]Show/hide columns in MS – Image Analyzer Tags table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Detected On Item No  | nvarchar(40) | ||||
| 3 | Tag Name | nvarchar(500) | ||||
| 4 | Tag Confidence | decimal(38,38) | ||||
| 5 | Item Category Code | nvarchar(40) | ||||
Key to join to the Item Category table.Show/hide example querySELECT
[MS - Image Analyzer Tags].[Item Category Code]
,[Item Category].[Code]
FROM
[CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags]
LEFT JOIN
[CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
ON
[MS - Image Analyzer Tags].[Item Category Code] = [Item Category].[Code] | ||||||
| 6 | Newly Created Item Category Code | tinyint | ||||
| 7 | Item Attribute Value Id | int | ||||
| 8 | Action To Perform | int | ||||
| 9 | Details Text | nvarchar(500) | ||||
| 10 | Item Attribute Name Id | int | ||||
| 11 | Item Attribute Name | nvarchar(500) | ||||
| 12 | Item Attribute Value Name | nvarchar(500) | ||||
| 13 | $systemId | uniqueidentifier | ||||
| 14 | $systemCreatedAt | datetime | ||||
| 15 | $systemCreatedBy | uniqueidentifier | ||||
| 16 | $systemModifiedAt | datetime | ||||
| 17 | $systemModifiedBy | uniqueidentifier | ||||