• State Verified Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 3 replies
  • Subscribers 95 subscribers
  • Views 2377 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to retrieve data from Column where Column name is stored in a variable

Guru
over 6 years ago

How to retrieve data from Column where Column name is stored in a variable

Something like value("abc")=$value("columnname")$

Parents Reply Children
  • 0 over 6 years ago in reply to Markus Weiss-Ehlers

    I want this code to be executed in script

  • +1 over 6 years ago in reply to Guru

    In a matter of fact, in a script, you cannot use the $-notation so you have to use the methods available at the IEntity object.

    In your case, that would be the GetValue method.

    Dim myEntity as IEntity
Dim ColumnToFetchAs String
Dim value as String

myEntity = Session.Source.CreateNew("Person")
ColumnToFetch = "InternalName"
value = myEntity.GetValue(ColumnToFetch).String

    Please take a look at the ScriptSamples in the SDK on the product delivery for more information. (<OneIM>\Modules\QBM\dvd\AddOn\SDK\ScriptSamples\)