MS – Image Analyzer Tags

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

Table Number: 2028

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]
LEFT JOIN
   [CRONUS UK Ltd_$Item Attribute Value$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attribute Value]
      ON
         [MS - Image Analyzer Tags].[Item Attribute Value ID] = [Item Attribute Value].[ID]
LEFT JOIN
   [User] AS [User]
      ON
         [MS - Image Analyzer Tags].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [MS - Image Analyzer Tags].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in MS – Image Analyzer Tags table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Detected On Item No Primary Key SearchDetected On Item NoNormalCode20Detected On Item Nonvarchar(40)
2Tag Confidence SearchConfidence Score (%)NormalDecimal12Tag Confidencedecimal(38,38)
3Tag Name Primary Key SearchDetected Attribute NameNormalText250Tag Namenvarchar(500)
4Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [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]
5Newly Created Item Category Co SearchNewly Created Item Category CodeNormalBoolean4
6Item Attribute Value Id SearchItem Attribute Value IdNormalInteger4Item Attribute Value Idint
Key to join to the Item Attribute Value table.

Show/hide example query

SELECT
       [MS - Image Analyzer Tags].[Item Attribute Value Id]
       ,[Item Attribute Value].[ID]
FROM
       [CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags]
LEFT JOIN
       [CRONUS UK Ltd_$Item Attribute Value$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attribute Value]
              ON
                     [MS - Image Analyzer Tags].[Item Attribute Value Id] = [Item Attribute Value].[ID]
7Action To Perform SearchAction to PerformNormalOption4Action To Performint
Available options are:
  • ” “
  • “Category”
  • “Attribute”
  • “Blacklist”
8Details Text SearchDetailsNormalText250Details Textnvarchar(500)
9Item Attribute Name Id SearchItem Attribute Name IdNormalInteger4Item Attribute Name Idint
10Item Attribute Name SearchItem Attribute NameNormalText250Item Attribute Namenvarchar(500)
11Item Attribute Value Name SearchItem Attribute Value NameNormalText250Item Attribute Value Namenvarchar(500)
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
       [MS - Image Analyzer Tags].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags]
LEFT JOIN
       [User] AS [User]
              ON
                     [MS - Image Analyzer Tags].[$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
       [MS - Image Analyzer Tags].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags]
LEFT JOIN
       [User] AS [User]
              ON
                     [MS - Image Analyzer Tags].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from MS – Image Analyzer Tags table

Leave a Reply

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