Skip to Content
avatar image
Former Member

Query Definition Master Agreement Document fields access

Hi,

How can I reference current document's fields (e.g. Business Unit) from within Query Definitions. I need to get the current doc Business Unit  OBJECTID while building a query definition for a report. There is no Token for accessing the current document, unless I do a pure sql lookup.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 04, 2012 at 09:20 AM

    Hi Tebogo,

    If you are on version 7.0 or higher please have a look at the GET token under query parameters

    It is of the format <%GET(CurrentDocument|CurrentBO)%>. Using this token you can get the current document or fields in the current document.

    I hope this points you to the correct direction. Let us know how it goes.

    Thanks

    Devesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Apologies, have not updated my progress on this issue, was deployed to another project for a short while I look at this tonight and post my findings\outcome.

      Thanks

      Tebogo