Reference dynamic metadata in CTL

jblythe99

• September 29, 2017 00:00

• Answered

Follow

Is it possible to reference dynamic metadata in CTL? It looks like the code to declare the metadata in CTL is:

<metadataname> mymetadata;

in which metadataname is the value in the "name" field on the "Record" tag in metadata. However, in dynamic metadata, there is not a record tag to be referenced. Is this not a possible option? I confirmed this by moving the "name" filed to the Metadata tag and it does not recognize this as metadata, even on User created metadata.

Any help would be appreciated.

• 

  Pedro Vazquez Rosario

  • October 06, 2017 16:20

  0

  Comment actions Permalink

  Hi jblythe99,
  
  In the case of Dynamic Metadata, it works a bit differently when referencing in CTL. The code to reference the dynamic metadata is:
  
  <tablename> mymetadata;
  
  TableName being the name of the table in the SQL query you are referencing.
  
  I would recommend having to parameters one for the SQLQuery and another for the TableName. That way you can just use the parameter in the CTL, thus having the process be more dynamic.
• 

  jblythe99

  • October 09, 2017 17:34

  0

  Comment actions Permalink

  Thank you! This is exactly what I needed.

Please sign in to leave a comment.