Filtering AND NOT NULL does not work for User

gvargasdc · 2010-02-08 20:03:15

Hi,

I am running GLPI 0.72.3. On Inventory -> Computers I am trying to apply the following filter:

"Laptops" in Type
AND NOT NULL in User

To display only the laptops that have been assigned to a user. But it does not work. When I click "search" it display all laptops (with our without assigned users).

I tried:

"Laptops" in Type
AND NULL in User

Just to see what happens, and that does work fine. But the reserve (which is what I want) does not.

I also tried "AND NOT [Nobody]" and "AND NOT 0" and they don't work either. I also tried AND NOT NULL with Name and that didn't work either. Two questions:

1. Does "AND NOT NULL" work?
2. Is there other way I can get the filter I want within GLPI?

Thanks for any help!

G.

yllen · 2010-02-08 20:46:07

I have the same problem.

gvargasdc wrote:

2. Is there other way I can get the filter I want within GLPI?

You can change your personal view to add user and order the result by clicking the name of the column

doum · 2010-02-08 21:29:48

If you want to see only laptops with a user assigned do :
"Laptops" in Type
AND ^ in User

But you're right, not null should work

gvargasdc · 2010-02-08 21:54:14

Thank you! Searching with AND ^ in User did it.

MoYo · 2010-02-08 22:11:23

corrected : https://forge.indepnet.net/repositories … glpi/10410

Shylie · 2024-08-27 16:53:05

Thank you so much

Forum GLPI-Project

Announcement

#1 2010-02-08 20:03:15

Filtering AND NOT NULL does not work for User

#2 2010-02-08 20:46:07

Re: Filtering AND NOT NULL does not work for User

#3 2010-02-08 21:29:48

Re: Filtering AND NOT NULL does not work for User

#4 2010-02-08 21:54:14

Re: Filtering AND NOT NULL does not work for User

#5 2010-02-08 22:11:23

Re: Filtering AND NOT NULL does not work for User

#6 2024-08-27 16:53:05

Re: Filtering AND NOT NULL does not work for User

Board footer