Knowledgebase:
Tag Groups with Writeback and Orderby
Posted by Linda, Last modified by on 15 May 2012 12:46 PM

EXAMPLE:

This report tags only one account in each group that it finds.

*** NOTE: This report works with cv11.5.2.1 and newer.

// This report uses ORDERBY to sort the groups before processing.

@tvarNum# = 0
@varNum# = 0
@tvarFlag = @mm.yasoao
@varSet* = NO
@de no total where ( @de.gr > 0 ) where ( @de.mo = Active ) where ( @de.sta = ACT ) orderby @de.gr
@varSet = NO
@varNum = @de.gr
@tvarFlag = ZZZZZZ if ( @varNum == @tvarNum )
@mm no total where ( @mm.yasoao = @tvarFlag ) max = 1
@de.fi< @de.gr< @de.sta<
@varSet = YES
@mm
@tvarNum = @de.gr
@tvarFlag = @mm.yasoao
@SETde.na.tag = 1 if ( @varSet = YES )
@de
@SETde.na.viewtags = 1

Select Edit from the top menu bar and then select View tags to
see your tagged list.

(0 vote(s))
Helpful
Not helpful

Comments (0)