By using the Static report, i can generate a template based on SQL. However, i would like to put all values of the dynamic fields from the same ticket to be generated on the same row.
For example,
[Ticket id 1 ] [Dynamic_Field1_value] [Dynamic_Field2_value]
[Ticket id 2 ] [Dynamic_Field1_value] [Dynamic_Field2_value]
I have tried to used the following code to get all the ticket id within the period of time.
Code: Select all
my $SQL1 ="select id,tn from ticket where create_time >= '$StartDate' and create_time <= '$EndDate' and queue_id = 8 order by id asc";
$DBObject->Prepare(SQL => $SQL1);
while (my @Row = $DBObject->FetchrowArray()) {
push @Data, [$Row[1]];
}
Code: Select all
push @DataToOutput, [$Data[0]];
Is that possible with the help of perl code ?
Best regards,
Frances Wong