Current User: Guest Login
Please consider registering


Lost Your Password?

Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Extra Section count query ranges

Reply to Post Add a New Topic
UserPost

2:24 pm
February 6, 2008


Tom

Guest

I'm trying to get a count on a query string w/ a range of values.  example, I want a count of all hits w/ catentry_id=2300000 through catentry_id=2302000.  Just a sum total is great, but I can't even see to get a row for each value.

 

This is what I'm trying, which the regex work form a grep:

ExtraSectionName1="Miss Prelims"
ExtraSectionCodeFilter1=""
ExtraSectionCondition1="URL,(.*)"
ExtraSectionFirstColumnValues1="QUERY_ STRING,catentry_id=(230[0-2][0-9]
[0-9][0-9])"
ExtraSectionFirstColumnTitle1="Miss Views"
ExtraSectionFirstColumnFormat1="%s"
ExtraSectionStatTypes1=PB
ExtraSectionAddSumRow1=1
MaxNbOfExtra1=1
MinHitExtra1=1
 

It seems that any range like [0-9] does not work.  I've also tries 230[012]…. w/o sucess.

 Any help is appreacitied.

Tom 

3:56 am
February 7, 2008


Jean-Luc

Admin

posts 1125

Hi,

You don't get a row for each value, because you specified that you only wanted one row with :

MaxNbOfExtra1=1

To get 10 rows, use :

MaxNbOfExtra1=10

If you only want one row with the total number of hits, use :

ExtraSectionFirstColumnValues1="QUERY_
STRING,catentry_id=(230)[0-2][0-9]
[0-9][0-9]"

Jean-Luc

6:31 pm
February 21, 2008


slick-willy

Guest

If you want catentry_id=2302000 to be included, but not catentry_id=23020001 or catentry_id=2302999, you'll need something different than what you tried, and what Jean-Luc suggested.

 Something like 

ExtraSectionFirstColumnValues1="QUERY_
STRING,catentry_id=(230)[0-1][0-9]
[0-9][0-9] || QUERY_STRING, catentry_id=2302000"

Reply to Post

Reply to Topic:
Extra Section count query ranges

Guest Name (Required):

Guest Email (Required):

NOTE: New Posts are subject to administrator approval before being displayed

Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
1 + 3
   


About the InternetOfficer.com Forum

Forum Timezone: UTC 1

Most Users Ever Online: 302

Currently Online:
57 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 2
Forums: 9
Topics: 638
Posts: 2709

Membership:

There are 257 Members
There have been 302 Guests

There is 1 Admin
There is 1 Moderator

Top Posters:

cssfsu – 55
deepakgupta – 34
albert_newton – 30
cosminpana – 20
DTNMike – 19
ahtshun83 – 17

Recent New Members: raju, todd2taylor, sbdcunha, mansigill1987, ThomasDuh, ThomasKic

Administrators: Jean-Luc (1125 Posts)

Moderators: Jean-Luc (1125 Posts)