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
G
Gregory SCHMID
said
3 months ago
Hi,
For a given entity, you have to look in SA_entity table and DA_BATCH table. Something like:
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 .
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
)
Gregory SCHMID
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
)
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 297 topics