Dynamic Table Names

Answered

Oliver Syner

• February 08, 2016 12:42

 Hello, 

Is there a way to return the current marketing documents object type into a SQL Report / Macro?

I know that there is the $[OQUT.ObjType] method but is there a way to dynamically change the table name  $[?.ObjType]?

I'm trying to avoid having to re-writ the same functions for each type of document when they all look at the same fields.

My apologies if this is something very simple or I am looking at it the wrong way, I'm still rather new to this.

 

Many Thanks

Oliver

Vote

1

• Official comment

  

  Yaremi Miranda Lopez

  • February 08, 2016 17:29

  Hello Oliver,

  To do this you need to create a Universal Function type Dynamic Code to get the value and then use it in a report, but you need programming skills. 

  Please contact your Partner and request Premium Support if needed.
• 

  Support

  • January 04, 2026 22:40

  This would be really handy to have available?

Please sign in to leave a comment.