IA search

[mouradhadj-]

Hello,

I am facing an issue while configuring a Search Source on the sc_task table. I want to filter records where:

1. The task was created by me (Created by is javascript:gs.getUserName())

2. The task is linked to a Request Item (sc_req_item) where I am the "Requested For" (Request Item.Requested For is (dynamic) Me)

However, when I try to save the condition Request Item.Requested For is (dynamic) Me, I get the following error:

Search Source condition could not be saved. See logs for details.

Looking at the logs, I found this error message:

Unsupported query column sc_task.request_item.requested_for

It seems that filtering directly on sc_task.request_item.requested_for is not supported.

Has anyone encountered this issue before?

• Is there a workaround to achieve this filtering in a Search Source?

• Is there another way to filter sc_task records based on requested_for?

Any guidance or alternative solutions would be greatly appreciated!

Thanks in advance!

[Vasantharajan N]

@mouradhadj-  Possible cause could be the indexed source may not include the dot walk reference. Please refer the KB link where it's explained. 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1002014

Please check whether this article helps

[mouradhadj-]

HI @Vasantharajan N ,

I don't have dot walk references, see my image  

[Vasantharajan N]

@mouradhadj- you are trying to dotwalk on RITM in sc_tasl and Requester for in RITM and these fields may not be included in the AI indexed source on which you try to create the Search profile.  Please include the RITM dotwalk and requester for in the indexed source which does the indexing of those records