Sub extendwhere (name, valvar_name) Let T = name & '_colname' ; Let COlname = $(T); Let values = (valvar_name); If len(Values) > 0 then If len(Where_part) > 0 then Let where_part = '$(Where_part) and match ("$(Col_name)",$(Values))'; else Let where_part = ' Where match ("$(Col_name)",$(Values))'; EndIf EndIf end sub;
Set FREQUENCY = ; Set FREQUENCY = $(odag_FREQUENCY); Set FREQUENCY_Colname = 'FREQUENCY' ;
sET wHERE_PART = '';
fOR EACH FLDNAME IN 'FREQUENCY' LET VALLIST = $($(FLDNAME)); WHEN (IsNull(VALLIST)) LET VALLIST = ''; IF LEN (VALLIST) > 0 THEN cALL EXTENDWHERE ('$(FLDNAME)','VALLIST');
EndIf Next FLDNAME
Trace GENERATED WHERE CLAUSE: ; TRACE $(WHERE_PART);
Here frequency is showing us Count of weekly , monthly and yearly activity. I am meeting all the ODAG criteria and when giving filter on frequency . (I selected monthly ) and even app is getting generated but it's coming up as same one(App showing Yearly, monthly , weekly) . but my expectation is to get monthly data only.
