Dynamically Invoking a Query Manager

[Former Member]

Has anyone out there figured out how to invoke Query Manager from a button? I would like to be able to add a button on the BP form to go out and query all of the Items the Customer has purchased. I would like to use a query written for the query manager to be able to do this? The query would have to contain an input parameter for the card code.

Any suggestions?

Thanks.

[Former Member · Accepted solution]

Yes:

You don't need an input parameter, 'cause the BP cardcode is on the BP form ($[$5.0.0]).

Your query will be something like this:

SELECT DISTINCT INV1.ItemCode FROM INV1 INNER JOIN OINV ON OINV.DocEntry = INV1.DocEntry WHERE OINV.CardCode = $[$5.0.0] ORDER BY ItemCode

HTH

Juha