Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0125-preview· OpenAIAi2 WildChat-4.8M (AI2)

in servicenow, i have a reference field named Asset in screqitem table and referring to…

  1. User

    in servicenow, i have a reference field named Asset in sc_req_item table and referring to alm_hardware table records when stockroom is selected. but in sc task table same Asset field used through dot walk but not showing any records to change. how to fix this

  2. Assistant

    To address the issue of a reference field (Asset) in the sc_req_item table (Service Catalog Request Item) successfully referring to alm_hardware table records based on certain criteria (e.g., stockroom selection) but not showing any records when attempting to change it through dot-walking on the sc_task table, you can follow these steps to troubleshoot and resolve the problem:

    1. Verify Reference Field Configuration

    First, ensure that the Asset field on both sc_req_item and via dot-walking from sc_task is correctly configured:

    • Check that the Asset field on sc_req_item is indeed referencing the alm_hardware table.
    • Verify that the dot-walking path you are using from sc_task to access the Asset field is correct. For example, if sc_task is related to sc_req_item through a field named request_item, you should be using request_item.asset to refer to the Asset.

    2. Check Access Control Rules (ACLs)

    • Sometimes, records may not be visible due to Access Control List (ACL) restrictions. Ensure there are no ACL rules on the alm_hardware table or the Asset field that prevent it from being displayed or edited in the context of sc_task.
    • Also, check whether there are any ACLs specifically targeting the dot-walking path or related fields that might restrict the visibility or editing capability.

    3. Evaluate Business Rules or Client Scripts

    • Investigate if there are any Business Rules or Client Scripts that could be affecting the visibility or editability of the Asset field when accessed through sc_task. Perhaps a script is conditionally restricting access based on the table or context in which the Asset field is being accessed.

    4. Review Reference Qualifiers

    • Reference qualifiers are used to filter the records that can be selected in a reference field. Verify if the Asset field has any reference qualifier applied that might be dynamically filtering out records under certain contexts, like when being accessed through sc_task instead of directly on sc_req_item.
    • If your reference field uses a dynamic reference qualifier (such as a Reference Qualifier Condition or a Scripted Reference Qualifier), ensure that the logic doesn’t inadvertently exclude records when accessed from sc_task.

    5. Test with Different Users

    • Test with users having different roles and permissions to see if the issue persists across different user contexts. This can help identify whether the problem is permission-related.

    6. Debug Logging

    • Utilize ServiceNow’s debugging tools to track what happens when you attempt to access or modify the Asset field through sc_task. Look at the logs to see if there are any errors or warnings that give clues as to what might be going wrong.

    Final Steps

    After checking these aspects, if the issue still persists, consider reaching out to the ServiceNow community forums or checking the official ServiceNow documentation for more specialized advice. Sometimes, issues can be very specific to the configuration and customization of your instance, and direct access or a detailed analysis may be required to resolve them.