SELECT DISTINCT st.id, st.tn, th.article_id .......; (correct sql left out - it works)
And all of this works.
I am having a problem making the "connection" from my populated SQL results generated in my new TicketSearch subroutine to my new module to display the results, based upon DashboardTicketGeneric.pm.
The code snippet from my new module (with BasicHistorySearch being my new search routine in which the sql above is called and results returned)
my @TicketIDsArray = $Self->{TicketObject}->BasicHistorySearch(
Result => 'ARRAY',
%TicketSearch,
%{ $TicketSearchSummary{ $Self->{Filter} } },
Limit => $Self->{PageShown} + $Self->{StartHit} - 1,
);
$TicketIDs = \@TicketIDsArray;
The searching is correct, but I cannot seem to pass the ArticleID in such a way that it can be accessed in the associated DTL file.
If you look in AgentDashboardTicketGeneric.dtl you will see the ArticleID reference, below,
<a href="$Env{"Baselink"}Action=AgentTicketZoom&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}&QueueID=$Data{"QueueID"}" onmouseover="window.status='$JSText{"Zoom"}'; return true;" onmouseout="window.status='';" title="$QData{"Title"}">$Data{"TicketNumber"}</a>
but it is never populated. I now have the Article ID available in the perl module that uses this layout, but cannot seem to access it.
Does that make any sense

If so, can anyone give me a bit of advice?
Thanks -
Jim