Use the search service to search for SAP SuccessFactors learning items

Table-Specific Information

Select

The server uses the SAPSuccessFactorsLMS API to process WHERE clause conditions that are built with the following columns and operators:

• ItemID supports the =, !=, and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
• ItemTypeID supports the =, !=, and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
• RevisionDate supports the =, >, <, >=, and <= comparison operators.
• Active supports the =, !=, IS, and IS NOT comparison operators.
• ClassificationID supports the =, !=, and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
• DeliveryMethodID supports the =, !=, and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
• DomainID supports the =, !=, and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
• ItemTitle supports the =, !=, and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.
• SourceID supports the =, !=, and LIKE comparison operators. Server-side support for the LIKE operator is restricted to CONTAINS clauses.

The server processes other filters client-side within the server.

For example, the following queries are processed server-side:

SELECT [Admin].[Search_Service].[Items].* FROM [Admin].[Search_Service].[Items]

Columns

Name	Type	References	Required for Select	Description
ItemID [KEY]	String			The unique ID of a learning item.
ItemTypeID [KEY]	String			Item type IDs are a critical categorization in because they determine how users are marked complete for a learning item. One item type can have completion statuses of pass and fail while another might have completion statuses of pass, fail and incomplete.
RevisionDate [KEY]	Datetime			The revision date of this entity. Learning items often have revision dates that correspond to a regulator's revision of compliance measures. Each later revision date is a later iteration of a learning item.
Active	Bool			Whether the item is active or not.
ClassificationID	String			The unique ID of the classification for a learning item. It can be: It can be one of the following values: BLENDED, CONTINUOUS ONLINE ACCESS, EXTERNAL-COURSE, PHYSICAL GOOD, or TIME-BASED.
DeliveryMethodID	String			The unique ID of a delivery method. A delivery method describes how a learning item will be delivered (for example, a book, PDF file, or online course). You can create or modify method IDs in the administration environment, in References: Learning: Delivery Methods
DomainID	String			The security domain ID of the entity. You can associate a record with an access domain to control the administrators who can access the record. What an administrator can access and do for a record depends on how you configured the entity, function, and workflow domain restrictions of the role ID that is associated with the administrator.
ItemTitle	String			The title of the learning item in the language of the current user (the user calling the web service). Titles can be translated using a key/value pair, where the key uniquely identifies a particular learning item's title and the values are each language's translation of the title. If you need the key that matches this value, and if the web service supports it, look in TitleLabelKey.
SourceID	String			The source is the developer of the learning item or the organization or regulatory body that requires it. You can create or modify source IDs in the administration environment, in References: Learning: Item Sources.
TotalCount	Long			The total number of records found for this request.