Hi ! Everybody, Is there anyone can help me on this topic?
I USE IFS8. In function Solution Manager\Configuration\Logs and Queues\Setup History Log, how can I see all settings existing quickly? So I know if they is the log setting already which I want. Otherwise I have to take about 3 minutes to find the component, table and field.
And is there anyone can give me a simple instruction on how to choice Sub forum? I really don’t know which sub forum should I select for this question.
Best answer by ShawnBerk
You should be able to run this from the SQL Query Tool or a Quick Report to see all of your settings.
select
hs.table_name,
hs.activate_cleanup,
hs.days_to_keep,
hsa.column_name,
hsa.log_delete,
hsa.log_insert,
hsa.log_update
from [yourinstance].history_setting_tab hs
LEFT JOIN [yourinstance].history_setting_attribute_tab hsa
ON
hs.table_name = hsa.table_name
ORDER BY hs.table_name
Framework & Experience is probably the correct sub-forum.
You should be able to run this from the SQL Query Tool or a Quick Report to see all of your settings.
select
hs.table_name,
hs.activate_cleanup,
hs.days_to_keep,
hsa.column_name,
hsa.log_delete,
hsa.log_insert,
hsa.log_update
from [yourinstance].history_setting_tab hs
LEFT JOIN [yourinstance].history_setting_attribute_tab hsa
ON
hs.table_name = hsa.table_name
ORDER BY hs.table_name
Framework & Experience is probably the correct sub-forum.
You should be able to run this from the SQL Query Tool or a Quick Report to see all of your settings.
select
hs.table_name,
hs.activate_cleanup,
hs.days_to_keep,
hsa.column_name,
hsa.log_delete,
hsa.log_insert,
hsa.log_update
from [yourinstance].history_setting_tab hs
LEFT JOIN [yourinstance].history_setting_attribute_tab hsa
ON
hs.table_name = hsa.table_name
ORDER BY hs.table_name
Framework & Experience is probably the correct sub-forum.
Thank you very much！
BR
Bright Zhao
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
