You are not logged in.
Pages: 1
Topic closed
Hello!
I've a problem with search engine.
I've tested this issue on glpi 0.78.2 and also on glpi 0.8 rc with the same result.
I've assigned two contract to some computer.
In the inventory i can see the contracts in column and are correct.
I want to know which computer has two contract activated.
On computer inventory in the search engine I've try to create the query as :
Item seen contains "pc"
AND contract name -> contract1
AND contract name -> contract2
and also as:
Item seen contains "pc"
AND contract name -> contract1
OR Item seen contains "pc"
AND contract name -> contract2.
No result with these query.
Can someone help me or this is a search engine bug?
thanks and sorry for my english.
Mariano
Glpi 0.84.8 - production and testing - OCS 2.1.2 - Mysql 5 - Apache 2 - php5 - Ubuntu server LTS 14.04 LTS
Plugins: behaviour, position, generic object, sim management, web services, projects _______________________________________________
Offline
I don't think this is possible with the search engine.
Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/
Offline
I don't think this is possible with the search engine.
Sorry but I don't understand why...
Have you any idea or other way to create a query obtaining these informations trough glpi. Is very important for us.
thanks
Mariano
Glpi 0.84.8 - production and testing - OCS 2.1.2 - Mysql 5 - Apache 2 - php5 - Ubuntu server LTS 14.04 LTS
Plugins: behaviour, position, generic object, sim management, web services, projects _______________________________________________
Offline
> I don't understand why...
When you search, all criteria apply to the same "contract", so no contract could have name = foo AND name = bar
Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/
Offline
Sorry but it is a nonsense ....
I can have a contract SLA for support with a supplier
and a Leasing contract with another.
I've try also in the contract page but in in the search engine the red icon "+" does'nt esist and I can't search object connected.
Glpi 0.84.8 - production and testing - OCS 2.1.2 - Mysql 5 - Apache 2 - php5 - Ubuntu server LTS 14.04 LTS
Plugins: behaviour, position, generic object, sim management, web services, projects _______________________________________________
Offline
Hello caiman68,
The search engine builds the SQL sentence dinamically, so when you add a contract condition it add a new table to the sencente. When you add the second contract condition the search engine don't add a new table because it already did it. So when a new where condition is added it's imposible that "column = value1 and column = value2" gives you any result.
That's because remi said the criteria apply to the same contract (table).
I hope this helps you to understand why the search engine doesn't support this.
Plugin genericassets
Go and use it!
Offline
Thank you for the reply FranciX,
But this not solve my problem.
I don't know any solution to retrieve these information without create an sql query directly on mysql.
This is not simply if the person don't have direct access to Mysql server .
Have you another alternative for these type of query?
thanks
Mariano
Glpi 0.84.8 - production and testing - OCS 2.1.2 - Mysql 5 - Apache 2 - php5 - Ubuntu server LTS 14.04 LTS
Plugins: behaviour, position, generic object, sim management, web services, projects _______________________________________________
Offline
Actually i think you must create a specific report for the plugin report.
For the future I create a ticket for next version of glpi : https://forge.indepnet.net/issues/2826
JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au projet GLPI : Soutenir
Offline
Actually i think you must create a specific report for the plugin report.
For the future I create a ticket for next version of glpi : https://forge.indepnet.net/issues/2826
Thanks for reply
I try to test the report plugin.
Thank you
Mariano
Glpi 0.84.8 - production and testing - OCS 2.1.2 - Mysql 5 - Apache 2 - php5 - Ubuntu server LTS 14.04 LTS
Plugins: behaviour, position, generic object, sim management, web services, projects _______________________________________________
Offline
Actually i think you must create a specific report for the plugin report.
For the future I create a ticket for next version of glpi : https://forge.indepnet.net/issues/2826
But why for the next version of GLPI?
In a company when there is a GLPI in production, it's possible to proceed to upgrade when there is a new feature in another version?
is it not possible to add these feature in the last GLPI package with the same code version (i,.e. all the version with 0.78.x) ?
thanks
Roberto
Offline
hello,
I've tried today the last version of glpi (0.81) in a test enviroment but the problem whit the search engine is not solved (all is the same).
Someone have notice about that?
thanks
Mariano
Glpi 0.84.8 - production and testing - OCS 2.1.2 - Mysql 5 - Apache 2 - php5 - Ubuntu server LTS 14.04 LTS
Plugins: behaviour, position, generic object, sim management, web services, projects _______________________________________________
Offline
Caimano : the ticket is not closed so it's normal that you don't find it in the 0,81 version of GLPI... You must be patient...
robbiefpi :
But why for the next version of GLPI?
Because this is our workflow... We could'not maintain more than one version at a time...
In a company when there is a GLPI in production, it's possible to proceed to upgrade when there is a new feature in another version?
You have the code of GLPI you could do anything if you have the skills needed...
is it not possible to add these feature in the last GLPI package with the same code version (i,.e. all the version with 0.78.x) ?
Again, You have the code of GLPI you could do anything if you have the skills needed... But it would take some time to do this...
JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au projet GLPI : Soutenir
Offline
hello,
I've tried today the last version of glpi (0.80.4) in a test enviroment. I've see that the ticket that was opened is closed as solved but the problem whit the search engine for me still the same.
Can someone help me to create a correct query for that?
thanks
Mariano
Glpi 0.84.8 - production and testing - OCS 2.1.2 - Mysql 5 - Apache 2 - php5 - Ubuntu server LTS 14.04 LTS
Plugins: behaviour, position, generic object, sim management, web services, projects _______________________________________________
Offline
hello, crate training puppies puppy aggression puppy whining dog growling weaning puppies puppy chewing
I've tried today the last version of glpi (0.80.4) in a test enviroment. I've see that the ticket that was opened is closed as solved but the problem whit the search engine for me still the same. puppy separation anxiety puppy crying leash training puppies why do dogs eat grass why do dogs eat poop puppy toilet training puppy training
Can someone help me to create a correct query for that? puppy training tips puppy barking puppy biting house training a puppy how much should i feed my puppypuppy buy marijuana seeds buy weed seeds buy cannabis seeds
thanks cannabis seeds for sale pot seeds northern lights weed a b c d e f g h i j k l m n o p q r
Mariano
Hello Mariano,
Did you sort this out? Or did you start a new thread?
I need to do this too
Last edited by Cjxy (2011-10-16 20:51:56)
Offline
Hello Cjxy.
I haven't solved the problem and I haven't open another thread because my test enviroment was removed by my collegue.
I have to reinstall glpi and reinsert many data and I have few time for testing.
I've tryed many query without success.
If you want open a bug as Jmd told .
I would have preferred to insert the bug with more data an test data to have a better reply.
Mariano
Glpi 0.84.8 - production and testing - OCS 2.1.2 - Mysql 5 - Apache 2 - php5 - Ubuntu server LTS 14.04 LTS
Plugins: behaviour, position, generic object, sim management, web services, projects _______________________________________________
Offline
Pages: 1
Topic closed