Remove the “not equal” operator from UUID fields

Description

NOTE: this issue will be mitigated by removing the “not equal” operator from UUID fields.

previous name: [QB] [Holdings] The operator "not equal" returns empty values along with available values

________

ENV: Snapshot

PRE-CONDITION:

  • Holding ET is selected

  • QB is opened

STEPS.

  1. Select any UUID field, ex. - Holdings — Holding — Holding type UUID

  2. Select operator - not equal

  3. Enter value - “anything”

  4. Click on “Test query”

ACTUAL RESULT: The query returns empty values as well.

  • Holdings — Holding — Created by user UUID

  • Holdings — Holding — Holding type UUID

  • Holdings — Holding — Permanent location UUID

  • Holdings — Holding — Source UUID

  • Holdings — Holding — Temporary location UUID

  • Holdings — Holding — Updated by user UUID

  • Holdings — Holding — UUID

  • Holdings — Holding — ILL policy UUID

  • Holdings — Holding — Instance UUID

Environment

None

Potential Workaround

None

Attachments

2

Checklist

hide

Activity

Show:

Kathleen Moore November 4, 2024 at 9:12 PM

confirmed on snapshot

Emma_Haroyan October 31, 2024 at 6:01 PM

Thanks All looks good on Rancher

Kriti Jain October 31, 2024 at 1:26 PM

the dataType was set incorrectly on those fiels. It will be fixed now

Kathleen Moore October 31, 2024 at 12:20 PM

- is there a technical reason these are different? if not, can we update the two fields that Emma mentioned?

Emma_Haroyan October 31, 2024 at 4:52 AM

Tested on Snapshot

The field “not equal to" is still available in the “Users” ET for these 2 fields:

  • User — Created by user UUID

  • User — Updated by user UUID

These 2 uuid type fields are the only fields, which have “Contains” and “Starts with” operators, instead of “IN” and “NOT IN”.

Is this expected?

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Corsair

Release

Ramsons (R2 2024) Bug Fix

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created October 8, 2024 at 8:01 PM
Updated December 12, 2024 at 7:52 PM
Resolved November 4, 2024 at 9:12 PM
TestRail: Cases
TestRail: Runs