How to call SQL Box with URL

[gyarakilaszlo]

Hi All,

I would like to ask for your assistance with creating a new menu, which redirects to the SQL box. The link partially works as follows:

Code: Select all

Action=AdminSelectBox;SQL=SELECT%20COUNT(*)%20FROM%20ticket_history%20WHERE%20ticket_id%20%3D%20[% Data.TicketID | html %];ResultFormat=Excel;Action=Run

In the link the format and query doesn't work. By what parameters could be these two fields called?

Thank you for your assistance in advance.