Share
ReportHi
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 ?
You’re offline. This is a read only version of the page.
410
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 ?
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (