I have a many of inactive users, but itop didnt show this Person and didn't show any error message.
For example SQL: SELECT * FROM contact WHERE status = "inactive"; Showing rows 0 - 24 (126 total, Query took 0.0007 seconds.)
Last edit: janis 2022-04-13
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
But it might be related to your user preference, if you say uncheck "Show obsolete data" (it's the default in user preference, then your query returns nothing. Otherwise, it works.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
SELECT Person WHERE status='inactive' do not work
Which error do you get? It seems fine at first sight (haven't tested it yet)?
Query Results - empty in iTop Run queries utilities
Last edit: janis 2022-04-13
But it didn't show an error message that your query was invalid? Are there inactive people?
I have a many of inactive users, but itop didnt show this Person and didn't show any error message.
For example SQL: SELECT * FROM
contactWHEREstatus= "inactive"; Showing rows 0 - 24 (126 total, Query took 0.0007 seconds.)Last edit: janis 2022-04-13
Hello Janis,
Thanks for this report. I have reproduce the issue in 3.0.0... In which version are you testing ?
iTop version 3.0.0-8663
But it might be related to your user preference, if you say uncheck "Show obsolete data" (it's the default in user preference, then your query returns nothing. Otherwise, it works.
thx Vincent @ Combodo , it works
Last edit: janis 2022-04-13