on 07-03-2012 2:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We are using version 5, we still need to upgrade to 7 or 8. Is this going to work in version 5 because this does not come up on the list of Tokens in version 5. Tried it as well and does not resolve to the object's value instead the query fails.
If anybody is using version 5 please assist.
Thanks
Tebogo
Hi Tebego,
You can try another approach then.
While writing the query definition make a hidden filter prompt of object reference type which refers the Master Agreement class (1004). Make sure to use this filter prompt in the query in order to restrict your result set to the current document (e.g. T1.OBJECTID = ? )
Now, create a report of Master Agreement category and add this query as the report element. Run this newly created report from you MA and see if you get the results as you require.
Keep us posted on this.
Thanks
Devesh
User | Count |
---|---|
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.