To enable the "golden arrow" feature inside your query portal queries follow these steps:

1) Add the following three columns to your query:

'oOrders' as Z_TYPE, DocEntry as Z_PRIMARY, DocNum as Z_DISPLAY

Z_TYPE = DI API object Type (oOrders, oInvoices, etc..)
Z_PRIMARY = Internal B1 Key of the object (DocEntry for example)
Z_DISPLAY = Value to display to user (DocNum for example)


2) Save your query back in your Business One B1WebAPI category with those new columns.
- If you have caching enabled you will need to refresh your web server to see the changes

3) If you are on version 1.01 of the Query Portal you will need to update the files gridviewer.aspx, OrderDetails.xslt and add a new image to the Query Portal. This functionality is included in version 1.1 out of the box. Contact our support to get these updated files.


4) Browse to the Query Portal website and view your updated query. The grid view of the data should now contain a "golden arrow" drill down that links to the details of the document in your query.