in servicenow, i have a reference field named Asset in screqitem table and referring to…
- 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
- Assistant
To address the issue of a reference field (Asset) in the
sc_req_itemtable (Service Catalog Request Item) successfully referring toalm_hardwaretable records based on certain criteria (e.g., stockroom selection) but not showing any records when attempting to change it through dot-walking on thesc_tasktable, 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_itemand via dot-walking fromsc_taskis correctly configured:- Check that the Asset field on
sc_req_itemis indeed referencing thealm_hardwaretable. - Verify that the dot-walking path you are using from
sc_taskto access the Asset field is correct. For example, ifsc_taskis related tosc_req_itemthrough a field namedrequest_item, you should be usingrequest_item.assetto 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_hardwaretable or the Asset field that prevent it from being displayed or edited in the context ofsc_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_taskinstead of directly onsc_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.
- Check that the Asset field on