SAP Knowledge Base Article - Public

2752912 - Extract URL details contained within the Item Description

Symptom

Where in the database tables can you located the URL details which are contained with the description of an Item

item url.jpg

Environment

  • SAP SuccessFactors Learning Management System (LMS) - All Supported Versions
  • Plateau Report Designer - PRD

Resolution

The URL which is saved within the Item description can be found in the PA_I18N_LOCALIZED_LABEL table.

Firstly you will have to get the HTML_DESC_LABEL_ID value from the PA_CPNT table for your item. Use this to reference the PA_I18N_LOCALIZED_LABEL table. The LABEL_VALUE column has the url within.

item db url.jpg

Keywords

URL, Item description, PA_I18N_LOCALIZED_LABEL, HTML_DESC_LABEL_ID, PA_CPNT , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions