One Star

How to display last record from table in jasper

I run a procedure , output of that procedure is stored in one table . I want to print the last record from that table....
Is this possible , i tired tMSSqllastinserted and tlogrow , i getting only Null values . am using 3.2.1 version ....
Any suggestions ?
Thanks
Vikram
3 REPLIES
Community Manager

Re: How to display last record from table in jasper

Hi
Where do you execute the procedure? tMssqlRow? Can you upload a screenshot of job?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: How to display last record from table in jasper

UPDINS is the procedure which i call , i load the output of the procedure in another table ....
I want display the message of the procedure thru Jasper ..
Community Manager

Re: How to display last record from table in jasper

Hi
tMSSqllastinserted can't get last inserted id from the reproduce, you should use the tMssqlInput to query the last records after you call the reproduce. For example:
tMssqlConnection
|
onsubjobok
|
tMssqlsp
|
tMssqlnput--main--tLogRow
|
tMssqlClose
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business