Why after business rule on text_search table on working ?

[Kavyashri Naval]

Hi Community,

I got a requirement to track what users are searching on Workspace global search. There is OOB 'text_search' table which is storing all these records from global search.

We have a custom 'u_audit' table & have a after -insert BR which is on text_search table.  So when record created in text_search table, it should create a new record in audit table. However BR is not working. Below is the BR:-

Note:- text_search is on global scope & custom 'u_audit' table is on Custom scope. Also same script when ran from background script is working & creating new audit record. This is weird. Can someone please help on this?

Thanks,

Ankita

[Daniel Borkowi1]

Did you found the log entries in the System log - because I tried in my PDI and the BR was executed. How does "When to run" look?

[Kavyashri Naval]

@Daniel Borkowi1 ,

No logs are not displaying in system log.

Below is the when to run condition:-

Have you used the same BR in your PDI?

[Daniel Borkowi1 · Accepted solution]

Hi@Kavyashri Naval , the global search was the missing information for me - this is also not working in my PDI. It seems that this is internally built without executing Business Rules, I assume to avoid performance issues.  My recommendation is here, that you should build a scheduled job (running once a hour), which collects all text_search entries created or updated (maybe update is not needed) last hour and insert them in u_audit. 

Greets
Daniel

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Kavyashri Naval]

Thank you @Daniel Borkowi1 for your time & valuable response.