last batch_id : Portal

Start a new topic

Answered

last batch_id

Yohann PLOIVY

started a topic almost 2 years ago

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 .

Best Answer

Gregory SCHMID said almost 2 years ago

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
)

1 Comment

Gregory SCHMID

said almost 2 years ago

Answer

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
)