This example shows you how to retrieve data from the Helpdesk database using a parameter in a SQL Query. Using the query/script generator you will build an integration component and use the listitemscomponent to display the current users incidents.
Click to view.
Note:I use a parameter in my where clause for the contact ID
Use the following variables:
Example:
You can leave the ID blank... it will successfully return the needed data, also without any ID specified
In "Create Query Script Article", step 15, when click on return data, it pops up a dialog (edit object) asking for Contact ID field (as it is blank). Are we leaving it blank?