bug(web-ng): srql query w/ filter around discovery_sources failing #720

New issue

Closed

opened 2026-03-28 04:27:48 +00:00 by mfreeman451 · 1 comment

mfreeman451 commented

2026-03-28 04:27:48 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #2255
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2255
Original created: 2026-01-11T22:59:27Z

Describe the bug

SRQL error: %Ash.Error.Unknown{bread_crumbs: ["Error returned from: ServiceRadar.Inventory.Device.read"], query: "#Query<>", errors: [%Ash.Error.Unknown.UnknownError{error: "** (Postgrex.Error) ERROR 42883 (undefined_function) operator does not exist: text[] ~~ unknown\n\n query: SELECT o0.\"discovery_sources\", o0.\"risk_level_id\", o0.\"org\", o0.\"modified_time\", o0.\"type_id\", o0.\"risk_score\", o0.\"region\", o0.\"mac\", o0.\"owner\", o0.\"is_available\", o0.\"uid_alt\", o0.\"group_id\", o0.\"subnet_uid\", o0.\"hostname\", o0.\"name\", o0.\"metadata\", o0.\"agent_id\", o0.\"model\", o0.\"vendor_name\", o0.\"last_seen_time\", o0.\"hw_info\", o0.\"agent_list\", o0.\"is_compliant\", o0.\"zone\", o0.\"is_trusted\", o0.\"type\", o0.\"vlan_uid\", o0.\"uid\", o0.\"os\", o0.\"risk_level\", o0.\"gateway_id\", o0.\"domain\", o0.\"groups\", o0.\"ip\", o0.\"created_time\", o0.\"first_seen_time\", o0.\"is_managed\", o0.\"network_interfaces\" FROM \"tenant_platform\".\"ocsf_devices\" AS o0 WHERE (o0.\"discovery_sources\"::text[] LIKE $1) ORDER BY o0.\"last_seen_time\" DESC LIMIT $2\n\n hint: No operator matches the given name and argument types. You might need to add explicit type casts.", field: nil, value: nil, splode: Ash.Error, bread_crumbs: ["Error returned from: ServiceRadar.Inventory.Device.read"], vars: [], path: [], stacktrace: #Splode.Stacktrace<>, class: :unknown}]}

To Reproduce
Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]

Smartphone (please complete the following information):

Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]

Additional context
Add any other context about the problem here.

Imported from GitHub. Original GitHub issue: #2255 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2255 Original created: 2026-01-11T22:59:27Z --- **Describe the bug** ``` SRQL error: %Ash.Error.Unknown{bread_crumbs: ["Error returned from: ServiceRadar.Inventory.Device.read"], query: "#Query<>", errors: [%Ash.Error.Unknown.UnknownError{error: "** (Postgrex.Error) ERROR 42883 (undefined_function) operator does not exist: text[] ~~ unknown\n\n query: SELECT o0.\"discovery_sources\", o0.\"risk_level_id\", o0.\"org\", o0.\"modified_time\", o0.\"type_id\", o0.\"risk_score\", o0.\"region\", o0.\"mac\", o0.\"owner\", o0.\"is_available\", o0.\"uid_alt\", o0.\"group_id\", o0.\"subnet_uid\", o0.\"hostname\", o0.\"name\", o0.\"metadata\", o0.\"agent_id\", o0.\"model\", o0.\"vendor_name\", o0.\"last_seen_time\", o0.\"hw_info\", o0.\"agent_list\", o0.\"is_compliant\", o0.\"zone\", o0.\"is_trusted\", o0.\"type\", o0.\"vlan_uid\", o0.\"uid\", o0.\"os\", o0.\"risk_level\", o0.\"gateway_id\", o0.\"domain\", o0.\"groups\", o0.\"ip\", o0.\"created_time\", o0.\"first_seen_time\", o0.\"is_managed\", o0.\"network_interfaces\" FROM \"tenant_platform\".\"ocsf_devices\" AS o0 WHERE (o0.\"discovery_sources\"::text[] LIKE $1) ORDER BY o0.\"last_seen_time\" DESC LIMIT $2\n\n hint: No operator matches the given name and argument types. You might need to add explicit type casts.", field: nil, value: nil, splode: Ash.Error, bread_crumbs: ["Error returned from: ServiceRadar.Inventory.Device.read"], vars: [], path: [], stacktrace: #Splode.Stacktrace<>, class: :unknown}]} ``` **To Reproduce** Steps to reproduce the behavior: 1. Go to '...' 2. Click on '....' 3. Scroll down to '....' 4. See error **Expected behavior** A clear and concise description of what you expected to happen. **Screenshots** If applicable, add screenshots to help explain your problem. **Desktop (please complete the following information):** - OS: [e.g. iOS] - Browser [e.g. chrome, safari] - Version [e.g. 22] **Smartphone (please complete the following information):** - Device: [e.g. iPhone6] - OS: [e.g. iOS8.1] - Browser [e.g. stock browser, safari] - Version [e.g. 22] **Additional context** Add any other context about the problem here.

mfreeman451 commented

2026-03-28 04:27:49 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2255#issuecomment-3765091002
Original created: 2026-01-18T09:17:33Z

closing, fixed

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2255#issuecomment-3765091002 Original created: 2026-01-18T09:17:33Z --- closing, fixed