Forum Discussion

MarcusH's avatar
MarcusH
Valued Contributor
2 years ago
Solved

Get stored value of Entity Relationship property

I am trying to get a stored value in Text1 from an Entity relationship: This is the code that at least does not give me an error when it executes but it does not return the Text1 value. Dim m...
Finance
NicolasArgente's avatar
NicolasArgente
Valued Contributor
2 years ago

Hey Marcus, 
There is a native easier function to do that :

Dim sValue As String = BRApi.Finance.Entity.RelationshipText(si, _
    entityId, parentId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId)

sValue = BRApi.Finance.Entity.RelationshipText(si, 0, -2, 900100, 0, 2021009000)

But to be honest, I tried it on my side without success. No idea why. It seems pretty straighforward but no success!

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    2 years ago

    It works for me - I think the problem with your code is the 4th parameter - textPropertyIndex - I think that should not be 0.

    Thank you. I really appreciate that you have taken the time to sort out the problem.

    • NicolasArgente's avatar
      NicolasArgente
      Valued Contributor
      2 years ago

      Oh! You are correct - I did not spot that! Thanks MarcusH  for the feedback. Appreciated.