Inventory - Enhanced / Relationship data - how to pass query/filter

[thedrew82]

Hi there - I'm trying to understand how to pass query parameters to the relationship query when enhanced is set to true. We have over 4 million rows in the relationship table which effectively makes walking the table without filtering impossible.

I basically only care about relationships with this filter applied:
"type.nameSTARTSWITHDepends on::Used by^child.sys_class_nameINSTANCEOFcmdb_ci_server^parent.sys_class_nameINSTANCEOFcmdb_ci_service_auto"

The now configuration doesn't support passing parameters to the relationship lookup - I've tried modifying the REL_QUERY with both the above and as an encoded version to no avail like below:

in https://github.com/ansible-collections/servicenow.itsm/blob/main/plugins/module_utils/relations.py#L31

# Similar as above but for sysparm_query
# REL_QUERY = None
REL_QUERY = 'type.nameSTARTSWITHDepends on::Used by^child.sys_class_nameINSTANCEOFcmdb_ci_server^parent.sys_class_nameINSTANCEOFcmdb_ci_service_auto'