Hi
I would like set up Database log for number sequence code.
But I can't find the table for this field ?
Can you suggest for this ?
Thank you all
The table is Number sequence group reference.
Hi Tanyaboon,
Can you search for the element 'Not specified' and there the number sequence section where you have multiple tables available for selection?
I don't know which one might be the right one but you could check and test this yourself in a demo/test environment.
Best regards,
Ludwig
++ just change the table num on the job.
Hi,
You can use below job to setup database log for your table instead of find it out manually.
static void AV_addTableToDatabaseLogSetup(Args _args)
{
databaselog databaselog;
TableId tableId = tableNum(NumberSequenceReference);
select firstonly databaselog where databaselog.logTable == tableId &&
databaselog.logType == databaselogType::Insert;
if (databaselog.RecId == 0)
{
databaselog.domainId = 'Admin';
databaselog.logType = databaselogType::Insert;
databaselog.logTable = tableId;
databaselog.logField = 0;
databaselog.insert();
}
select firstonly databaselog where databaselog.logTable == tableId &&
databaselog.logType == databaselogType::Update;
if (databaselog.RecId == 0)
{
databaselog.domainId = 'Admin';
databaselog.logType = databaselogType::Update;
databaselog.logTable = tableId;
databaselog.logField = 0;
databaselog.insert();
}
select firstonly databaselog where databaselog.logTable == tableId &&
databaselog.logType == databaselogType::Delete;
if (databaselog.RecId == 0)
{
databaselog.domainId = 'Admin';
databaselog.logType = databaselogType::Delete;
databaselog.logTable = tableId;
databaselog.logField = 0;
databaselog.insert();
}
select firstonly databaselog where databaselog.logTable == tableId &&
databaselog.logType == databaselogType::RenameKey;
if (databaselog.RecId == 0)
{
databaselog.domainId = 'Admin';
databaselog.logType = databaselogType::RenameKey;
databaselog.logTable = tableId;
databaselog.logField = 0;
databaselog.insert();
}
SysFlushDatabaseLogSetup::main();
}
Regards
Hi Tanyaboon,
The table used is NumberSequenceReference. It is part of the Organization administration area.
Hi,
Looks as if you are in the AR parameter form. Have you tried searching through the related tables and fields in the database log configuration form?
Best regards,
Ludwig
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156