OnDemand Users Group

Support Forums => Report Indexing => Topic started by: pankaj.puranik on November 29, 2010, 07:06:29 AM

Title: RECORDRANGE and GROUPRANGE
Post by: pankaj.puranik on November 29, 2010, 07:06:29 AM
Hi

Has anyone used the RECORDRANGE and GROUPRANGE parameters in the indexer program?
Could anyone share an example?

Thanks
Pankaj.
Title: Re: RECORDRANGE and GROUPRANGE
Post by: Greg Ira on December 01, 2010, 07:59:09 PM
Here is an example of GROUPRANGE.  This is indexing a large log file and the grouprange index will give me the start and end times for the log which are in the format hh:mm:ss 

FIELD1=0,12,6,(TRIGGER=1,BASE=0)
FIELD2=0,21,5,(TRIGGER=1,BASE=0)
FIELD3=*,*,8,(OFFSET=(27:34),MASK='##:##:##',ORDER=BYROW)
INDEX1=X'D985979699A36DD5819485',FIELD1,(TYPE=GROUP,BREAK=NO)     /* Report_Name */
INDEX2=X'D396876DC481A385',FIELD2,(TYPE=GROUP,BREAK=NO)           /* Log_Date    */
INDEX3=X'D396876DE3899485',FIELD3,(TYPE=GROUPRANGE,BREAK=NO)      /* Log_Time    */

Title: Re: RECORDRANGE and GROUPRANGE
Post by: Greg Ira on December 01, 2010, 08:16:51 PM
And to add to my previous post.  To use the index I have two fields defined:  Log_Time and Log_Time_end.  In the application under the Load Information tab in Preprocessor Parameters both those fields have Log_Time set as the Load ID name. 
Title: Re: RECORDRANGE and GROUPRANGE
Post by: pankaj.puranik on December 03, 2010, 07:28:59 AM
So that means GROUPRANGE is mainly used with transaction type of reports where I need the starting and ending values for a group, correct?
Title: Re: RECORDRANGE and GROUPRANGE
Post by: Greg Ira on December 03, 2010, 02:04:29 PM
Correct
Title: Re: RECORDRANGE and GROUPRANGE
Post by: pankaj.puranik on December 16, 2010, 08:10:22 AM
I also came across PAGERANGE.
Have you used pagerange also?