It is currently 21. Nov 2018, 08:56


Limit on Query Conditions?

Closed. Last version 5.11.0.5800.
Please always update v5.x to this version.

Moderator: Moderator Team

  • Author
  • Message
Offline

bwintern

Activist

Activist

  • Posts: 13
  • Joined: 12. May 2009, 20:18

Limit on Query Conditions?

Post20. Nov 2009, 16:12

I have built a query designed to generate a list of software that is installed on PCs that we do not support. The query is setup as follows:

Columns:
Name
Unique Identifier
Software Name
Software Install Date

Condition:
Or
[SOFTWARE_DISPNAME] Contains iTunes
[SOFTWARE_DISPNAME] Contains Business Contact Manager
[SOFTWARE_DISPNAME] Contains Total Security
[SOFTWARE_DISPNAME] Contains Coupon
[SOFTWARE_DISPNAME] Contains SearchAssist

Evaluation Time:
At this point in time Now

Display As:
as a list

However, I cannot add any more conditions. Whenever I try to add another item, such as
[SOFTWARE_DISPNAME] Contains Toolbar

The new condition appears, but when I click Apply and Ok, no results are returned. When you look at the query properties again, the condition you just added is no longer there. It appears that I cannot add more than 5 conditions per query. Is there a hard limit or is this a bug? You can change anything else about the query, such as the comments, and those stick even when the new condition does not.

LOGINventory 5 RC2. Access Database. Windows 7.
Offline
User avatar

RolandL

Site Admin

Site Admin

  • Posts: 769
  • Joined: 1. Sep 2003, 01:00
  • Location: Munich

Re: Limit on Query Conditions?

Post20. Nov 2009, 17:47

There should not be such a limit - but in fact there is one in RC2. :oops:

Thank you for reporting.

[Update: The database column type of LA_CONDITION has to be changed from NVARCHAR(255) to NTEXT.]
Last edited by Franky on 25. Nov 2009, 17:11, edited 1 time in total.
Reason: Bug reason added.
RolandL

Hello - IT! Have you tried turning it off and on again?
Next step: Check DNS.
http://www.loginventory.com

Return to LOGINventory5 English

Who is online

Users browsing this forum: No registered users and 1 guest

cron