Search for optional dropdown value

Moderator: crythias

Post Reply
disciple
Znuny newbie
Posts: 62
Joined: 31 Jul 2022, 12:27
Znuny Version: 6.4.2
Real Name: David Müller

Search for optional dropdown value

Post by disciple »

is it possible to use a search to find all non entered values of a dynamicField which is(was) optional?

E.g. if you have a select box with:

<nothing>
something1
something2
something3

i would like to search for <nothing>

maybe this is related to this: viewtopic.php?f=62&t=43230
root
Administrator
Posts: 3934
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Search for optional dropdown value

Post by root »

Hi,

No this is not possible. For this value there no entry in the table where the search is performed.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Johannes
Moderator
Posts: 391
Joined: 30 Jan 2008, 02:26
Znuny Version: All of them ^^
Real Name: Hannes
Company: Znuny|OTTERHUB

Re: Search for optional dropdown value

Post by Johannes »

Nope, it is not.
What you can do, is get a ticket list from the reporting, and search for the empty values.

It is basically the same as for your other question. As you guessed
disciple
Znuny newbie
Posts: 62
Joined: 31 Jul 2022, 12:27
Znuny Version: 6.4.2
Real Name: David Müller

Re: Search for optional dropdown value

Post by disciple »

root wrote: 25 Aug 2022, 15:44 Hi,

No this is not possible. For this value there no entry in the table where the search is performed.

- Roy
Thank you for your info.

I am not clear on what you refer to. On DB tables you can search

<> '' OR IS NULL
or some DBs
NOT IN ('', NULL)

But I assume you know this?!?

Also is there a plan to support such "basic" usage features?
it would make Znuny more usable
Johannes
Moderator
Posts: 391
Joined: 30 Jan 2008, 02:26
Znuny Version: All of them ^^
Real Name: Hannes
Company: Znuny|OTTERHUB

Re: Search for optional dropdown value

Post by Johannes »

Oh no, really. Glad you told us.
This solves this mystery.

*irony off*

We will. later. Probably. The list is long. The code is old. Things take time.
Post Reply