Hello Community,

I’m still a beginner with IFS Cloud, and I need your help with the page designer. For reference, we are using version 24R1.

I am trying to add a LOV (List of Values) in an IFS table to display related data. Specifically, on the Sub Contract Indemnities screen, I’d like to display the lines for Revision and Items.

To do this, I created a persistent field in the IndemnityRequest entity. However, when I try to access the values in the page configuration, I cannot retrieve the data I need, such as the keys that would allow me to filter values. Interestingly, if I concatenate the keys in the displayed values, I can access them.

The issue is that from this point, I don’t know how to use them because I’m unsure if there are any functions available to extract substrings based on a character separator and position.

Do you have any tips?

• Either a way to get the fields required to set up the Data Source Aggregate Refs.
• Or a method to extract concatenated substrings.

Thank you in advance for your help,
Louis Planquart