Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

DynamicField Reference SearchSQLGet sub buggy #3707

Open
stefanhaerter opened this issue Aug 14, 2024 · 0 comments · May be fixed by #3708
Open

DynamicField Reference SearchSQLGet sub buggy #3707

stefanhaerter opened this issue Aug 14, 2024 · 0 comments · May be fixed by #3708
Assignees
@stefanhaerter
Labels
bug Something isn't working as intended
Milestone
OTOBO 11.0.8

Comments

@stefanhaerter
Copy link
Contributor

The sub Kernel::System::DynamicField::Driver::BaseReference::SearchSQLGet() uses LOWER depending if the database supports it. PostgreSQL does, and so it tries to LOWER an integer value which throws an error.
@stefanhaerter stefanhaerter added the bug Something isn't working as intended label Aug 14, 2024
@stefanhaerter stefanhaerter added this to the OTOBO 11.0.6 milestone Aug 14, 2024
@stefanhaerter stefanhaerter self-assigned this Aug 14, 2024
stefanhaerter added a commit that referenced this issue Aug 14, 2024
@stefanhaerter
Issue #3707: Fixed lower handling in DF Reference SearchSQLGet.
898b141
stefanhaerter added a commit that referenced this issue Aug 14, 2024
@stefanhaerter
Issue #3707: Adapted search sql handling from BaseSelect.
46c82e3 
Since DF CustomerUser reference has text values, Lower handling is needed for it.
@stefanhaerter stefanhaerter linked a pull request Aug 14, 2024 that will close this issue
Open
@svenoe svenoe modified the milestones: OTOBO 11.0.6, OTOBO 11.0.7 Sep 25, 2024
@svenoe svenoe modified the milestones: OTOBO 11.0.7, OTOBO 11.0.8 Oct 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@stefanhaerter stefanhaerter

Labels
bug Something isn't working as intended
Projects
None yet
Milestone
OTOBO 11.0.8
Development

Successfully merging a pull request may close this issue.

Issue #3707 lower RotherOSS/otobo
2 participants
@stefanhaerter @svenoe