Forum Discussion

MarcusH's avatar
MarcusH
Contributor III
2 years ago

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
    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!

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
    Contributor III
    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.