22033 0 true 2009-04-21T03:55:36-04:00 54704 83 not_group-support 36996 16601 moved_to_github conditions group grouping not_group support 2009-08-07T18:30:04-04:00 22033 Ben Johnson sdecastelberg Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/83 hey, is something like a 'not_group' available within searchlogic (or in combination with ActiveRecord)? e.g.: s=System.new_search => #<SystemSearch {:limit=>25}> >> g=s.conditions.not_group => #<SystemConditions> >> g.name_equals="test" => "test" >> g.descr_equals="test" => "test" >> s.count => 95 generated sql: SQL (0.5ms) SELECT count("systems".id) AS count_id FROM "systems" WHERE (NOT (("systems"."name" = 'test' AND "systems"."descr" = 'test'))) hey, is something like a 'not_group' available within searchlogic (or in combination with ActiveRecord)? e.g.: s=System.new_search => #<SystemSearch {:limit=>25}> >> g=s.conditions.not_group => #<SystemConditions> >> g.name_equals="test" => "test" >> g.descr_equals="test" => "test" >> s.count => 95 generated sql: SQL (0.5ms) SELECT count("systems".id) AS count_id FROM "systems" WHERE (NOT (("systems"."name" = 'test' AND "systems"."descr" = 'test'))) <div><p>hey,</p> <p>is something like a 'not_group' available within searchlogic (or in combination with ActiveRecord)?</p> <p>e.g.: s=System.new_search =&gt; <a href="/projects/16601/tickets/25" title="Ticket #25">#25</a>}&gt;</p> <blockquote> <blockquote> <p>g=s.conditions.not_group =&gt; # g.name_equals="test" =&gt; "test" g.descr_equals="test" =&gt; "test" s.count =&gt; 95</p> </blockquote> </blockquote> <p>generated sql: SQL (0.5ms) SELECT count("systems".id) AS count_id FROM "systems" WHERE (NOT (("systems"."name" = 'test' AND "systems"."descr" = 'test')))</p></div> 22033 0 hey, is something like a 'not_group' available within searchlogic (or in combination with ActiveRecord)? e.g.: s=System.new_search => #<SystemSearch {:limit=>25}> >> g=s.conditions.not_group => #<SystemConditions> >> g.name_equals="test" => "test" >> g.descr_equals="test" => "test" >> s.count => 95 generated sql: SQL (0.5ms) SELECT count("systems".id) AS count_id FROM "systems" WHERE (NOT (("systems"."name" = 'test' AND "systems"."descr" = 'test'))) <div><p>hey,</p> <p>is something like a 'not_group' available within searchlogic (or in combination with ActiveRecord)?</p> <p>e.g.: s=System.new_search =&gt; #25}&gt;</p> <blockquote> <blockquote> <p>g=s.conditions.not_group =&gt; #g.name_equals="test" =&gt; "test" g.descr_equals="test" =&gt; "test" s.count =&gt; 95</p> </blockquote> </blockquote> <p>generated sql: SQL (0.5ms) SELECT count("systems".id) AS count_id FROM "systems" WHERE (NOT (("systems"."name" = 'test' AND "systems"."descr" = 'test')))</p></div> false 2009-04-21T03:55:36-04:00 54704 --- {} 83 not_group-support 0 16601 new conditions group grouping not_group support 2009-04-21T03:55:41-04:00 54704 sdecastelberg sdecastelberg Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/83 22033 0 After digging around, trying to find another solution without success I decided to implement that feature within searchlogic. The changes are committed to a fork of searchlogic (http://github.com/sdecastelberg/searchlogic/tree/master). Maybe someone can have a look at it. Feedback is appreciated. (i'm rather new to ruby/ror..) The implemented not_group works fine for my needs. <div><p>After digging around, trying to find another solution without success I decided to implement that feature within searchlogic. The changes are committed to a fork of searchlogic (<a href="http://github.com/sdecastelberg/searchlogic/tree/master)">http://github.com/sdecastelberg/...</a>. Maybe someone can have a look at it. Feedback is appreciated. (i'm rather new to ruby/ror..)</p> <p>The implemented not_group works fine for my needs.</p></div> false 2009-05-07T04:15:18-04:00 54704 --- {} 83 not_group-support 0 16601 new conditions group grouping not_group support 2009-05-07T04:15:22-04:00 54704 sdecastelberg sdecastelberg Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/83 22033 0 Why wouldn't you adjust your conditions to have the opposite effect instead of doing a not_group. Either way, whatever works for you, if you like the not_group solution then I think its fine, but couldn't you accomplish the same thing by adjusting your conditions? <div><p>Why wouldn't you adjust your conditions to have the opposite effect instead of doing a not_group. Either way, whatever works for you, if you like the not_group solution then I think its fine, but couldn't you accomplish the same thing by adjusting your conditions?</p></div> false 2009-06-03T04:07:50-04:00 54704 --- :state: new 83 not_group-support 0 16601 open conditions group grouping not_group support 2009-06-03T04:07:51-04:00 22033 Ben Johnson sdecastelberg Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/83 22033 0 the not_group was initially needed for a monitoring/inventory application to map network components (software and hardware) and provide configuration for different network and application layer scanners. For bulk editing, reporting, etc. we needed an exact match search for every single attribute on every model. Search Dialog ============== *group1 *SnmpScan (include) *oid=ssCpuIdle *alarm-threshold=90 *System (exclude) *Status=Test *Modified Date start: 2009-01-01 would match the following search (when searching for systems) (system.snmp_scan.oid=ssCpuIdle AND system.snmp_scan.alarm_threshold=90) AND NOT (system.state=Test AND modified_date>=2009-01-01) The attributes are grouped model-wise and can be combined differently (and, or) and the search can be expanded by adding other groups with subgroups. The include/exclude flag just sets the not_group attribute on the group, without having to negate all the single attributes. <div><p>the not_group was initially needed for a monitoring/inventory application to map network components (software and hardware) and provide configuration for different network and application layer scanners.</p> <p>For bulk editing, reporting, etc. we needed an exact match search for every single attribute on every model.</p> <h1>Search Dialog</h1> <p>*group1</p> <pre> <code>*SnmpScan (include) *oid=ssCpuIdle *alarm-threshold=90 *System (exclude) *Status=Test *Modified Date start: 2009-01-01</code> </pre> <p>would match the following search (when searching for systems)</p> <pre> <code>(system.snmp_scan.oid=ssCpuIdle AND system.snmp_scan.alarm_threshold=90) AND NOT (system.state=Test AND modified_date&gt;=2009-01-01)</code> </pre> <p>The attributes are grouped model-wise and can be combined differently (and, or) and the search can be expanded by adding other groups with subgroups.<br> The include/exclude flag just sets the not_group attribute on the group, without having to negate all the single attributes.</p></div> false 2009-06-03T17:58:15-04:00 54704 --- {} 83 not_group-support 0 16601 open conditions group grouping not_group support 2009-06-03T17:58:17-04:00 54704 sdecastelberg sdecastelberg Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/83 22033 0 I see what you're saying. But searchlogic deals with single conditions. If you are writing your own named scope for these conditions why not add in the "NOT" yourself? I guess I'm a little confused how you are using searchlogic and how you want to use it. <div><p>I see what you're saying. But searchlogic deals with single conditions. If you are writing your own named scope for these conditions why not add in the "NOT" yourself? I guess I'm a little confused how you are using searchlogic and how you want to use it.</p></div> false 2009-07-30T02:54:15-04:00 54704 --- {} 83 not_group-support 0 16601 open conditions group grouping not_group support 2009-07-30T02:54:16-04:00 22033 Ben Johnson sdecastelberg Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/83 22033 0 [state:"moved_to_github" bulk edit command] <div><p>[state:"moved_to_github" bulk edit command]</p></div> true 2009-08-07T18:30:04-04:00 54704 --- :state: open 83 not_group-support 0 16601 moved_to_github conditions group grouping not_group support 2009-08-07T18:30:04-04:00 22033 Ben Johnson sdecastelberg Ben Johnson http://binarylogic.lighthouseapp.com/projects/16601/tickets/83