Extract Text from Relational Database (PBCS)
I have a dimension called Product Code that has a data type of Text.
This dimension has been added to a form, and planners can add freeform text in the text box.
For this example, let's assume a planner has added product code "6110" in the text field.
I am able to retrieve the row id by passing "6110" to the following function: [[PlanningFunctions.getIDForString("6110")]]; this returns ID 1766.
Is there a similar function or trick where I can pass in the row id (1766), and return "6110"?
Thanks in advance!