Hi,

I have an alternative that could meet your business needs :

• Create a quick report based on history log table with a filter on Logical unit(s) and a parameter ‘Customer_id’ (see below for an example).
  You can also make a jointure with the history log record details table to see all information in one table.
• Grant this quick report projection to the correct permissions sets
• Create a new command on Customer record to execute a quick report : 
  • Select the quick report you just created
  • entrer the required parameters (CustomerId in my example)
  • Set direct execute to yes (so that when you click the button the data will be automatically calculated)

BR, 
Pierre
 

select
     HL.LOG_ID,
     HL.MODULE,
     HL.LU_NAME,
     HL.TABLE_NAME,
     HL.TIME_STAMP,
     HL.USERNAME,
     HL.HISTORY_TYPE,
     HL.KEYS,
     HLD.COLUMN_NAME,
     HLD.OLD_VALUE,
     HLD.NEW_VALUE

from 
     HISTORY_LOG HL
          join HISTORY_LOG_ATTR_JOIN HLD
               on HL.LOG_ID = HLD.LOG_ID

where 
     HL.LU_NAME like 'Customer%'
     and HL.KEYS like '%CUSTOMER_ID='||'&CustomerID'||'%'

Hi ​@MarDab ,

With Navigation Link we can only use ‘eq’ keyword, it’s not possible to use keywords like ‘startswith’, ‘contains’ etc. to filer with Navigation url. 

Instead you can use External Url Link to full fill this requirement, but I have noticed that we need to press Search button after navigating to the page to view the filtered data.

URL: https://xxxxxxxxx.ifs.cloud/main/ifsapplications/web/page/HistoryLog/List;$filter=%28startswith%28tolower%28Keys%29%2C%27CUSTOMER_ID%3D${CustomerId}%27%29%29

Press Search to view the data.

​@MarDab I’ve recently created a YT tutorial on exactly the solution that ​@ArcPierreL is mentioning.

I would rather go via Quick Reports since History Log page is difficult to read in one go - the user always needs to go from overview to the details page to see old/new values. Quick Report would show all the data you need at once.

Maybe it’s usefull. 

Thank you for your responses!

Indeed, the most convenient solution will be to create a Quick Report, so I’ll go with that option.

Best regards,

Marta