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
Search for optional dropdown value
Moderator: crythias
-
- 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
Hi,
No this is not possible. For this value there no entry in the table where the search is performed.
- Roy
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 ?
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 ?
-
- 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
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
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
-
- 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
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
-
- 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
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.
This solves this mystery.
*irony off*
We will. later. Probably. The list is long. The code is old. Things take time.