Hi,
For a given entity, you have to look in SA_entity table and DA_BATCH table.
Something like:
select batch.B_BATCHID
from DL_BATCH batch
left join SA_entity entity on entity.B_LOADID = batch.B_LOADID
where entity.B_LOADID =
(
select max(B_LOADID)
from SA_entity
)
Y. ploivy. ext
Hello ,
In a GD table , we would like to retrieve only the last batch_id . How do we proceed?
For our example :
We have a line that has been deleted in the source and no longer appears in the last batch_id . But it goes back up with the previous one and is therefore present in the GUI.
Thanks for your help .