ODBC Driver for Salesforce

Build 26.0.9770

CategoryNode

Represents hierarchical category structures used for organizing knowledge articles and content.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the category node.

ParentId String False

CategoryNode.Id

ID of the parent category node, used to define the hierarchical structure of categories.

MasterLabel String False

Display name of the category node.

SortOrder Int False

Position of this category node relative to its siblings, determining the display order.

SortStyle String False

Specifies how the subcategories under this category should be sorted.

CreatedDate Datetime True

Date and time when the category node was created.

CreatedById String True

User.Id

ID of the user who created the category node.

LastModifiedById String True

User.Id

ID of the user who last modified the category node.

SystemModstamp Datetime True

System-generated timestamp indicating the last update to this record.

LastModifiedDate Datetime True

Date and time when the category node was last modified.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
SOQL String

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770