• State Verified Answer
  • Replies 1 reply
  • Subscribers 95 subscribers
  • Views 1905 views
  • Users 0 members are here
Options
Related

SyncEditor - config parameters

Oliver H.
over 3 years ago

Is it possible to read config parameters within scripts of sync editor with a function or do I need to read those values from database table DialogConfigParm directly?

Parents
  • +1 over 3 years ago

    Option A would be to fetch the value of the configuration parameter using a scripted variable.

    return args.QueryDatabase(Connection.SystemQuery.From("DialogConfigParm").Select("Value").Filter("Fullpath='<Fullpath to ConfigParm>'")).Result.First.GetValue("Value").AsString

    Option B in a scripted property the code would look like this.

    Imports VI.Projector.Connection

Dim configparm = SystemObject.Connection.QueryObject(SystemQuery _
 .From("DialogConfigParm") _
 .Select("Value") _
 .Filter("Fullpath='<Fullpath to ConfigParm>'") _
 ).Result.First.GetValue("Value").AsString

Return configparm

    Additional Note

    You need to have the table DialogConfigParm in your schema of the Sync Project on the OneIM (left) side. To keep the table sticky during schema shrinks, you have to exclude the table from the schema shrink.

Reply
  • +1 over 3 years ago

    Option A would be to fetch the value of the configuration parameter using a scripted variable.

    return args.QueryDatabase(Connection.SystemQuery.From("DialogConfigParm").Select("Value").Filter("Fullpath='<Fullpath to ConfigParm>'")).Result.First.GetValue("Value").AsString

    Option B in a scripted property the code would look like this.

    Imports VI.Projector.Connection

Dim configparm = SystemObject.Connection.QueryObject(SystemQuery _
 .From("DialogConfigParm") _
 .Select("Value") _
 .Filter("Fullpath='<Fullpath to ConfigParm>'") _
 ).Result.First.GetValue("Value").AsString

Return configparm

    Additional Note

    You need to have the table DialogConfigParm in your schema of the Sync Project on the OneIM (left) side. To keep the table sticky during schema shrinks, you have to exclude the table from the schema shrink.

Children
No Data