Coding Help

[4Vikram]

I am trying to extract 'Y' as my output from this code,,, but dont know why throwing some error

 

FunctionField

  {

    FieldName = HasDailyConflict

    FieldDescription = Has daily based conflict (Y/N)

    Calc = {

case

when exists 

(

select 1 

from cfl, bkg

where 

cfl_res_id=BaseAlias.RES_ID

and cfl_bkg_id=bkg_id

and bkg_start<_ADDDAYS(#END, 1)

and bkg_end>=#START

)

and ConflictHoursDailyOT>0

then 'Y'

else 'N'

end

}

 

    FieldType = ftString

Flags=ReportsUse

    Category=Custom Reporting CalcFields

    FieldExplanation = {

Returns 'Y' if in the reporting date range there is at least one booking

in conflict

    }

  } 

 

 

Anyone please help in identifying the mistake

[chandra916]

em language idhi

[chandra916]

return 'Y' ante saripothundhi kadha

[Nene_Thopu]

return 'Y' ante saripothundhi kadha

[4Vikram]

return 'Y' ante saripothundhi kadha

mayya no jokes, please help

[chandra916]

emina thappu cheppana

[vikuba]

bro data chudakunda ne filters ni chusi Y endhuku ravatledhoo cheppalemu kani.

 

try debuggin the small chunks of code.

look at for ur filters...

 

[chandra916]

mayya no jokes, please help

inthaki adhi ee langugae oo cheppaledhu......jus LTT chesthunna

[Nene_Thopu]

emina thappu cheppana

100% correct ans ichaav...anduke naavvu vachindhi 

[4Vikram]

inthaki adhi ee langugae oo cheppaledhu......jus LTT chesthunna

madi oka musthi reporting tool undi mayya.. dantlo feilds extract cheyadanki cff file lo ee code rastamu... deeni ee language coding antaro ipatiki ardam kaledu

[mtkr]

Mayya.. joke gaa vesavaa serious gaa vesavaa???

nuv expect chesina result raavatledhu ante how yaa...

nuv pass chese inputs batti ni output untadii...

[4Vikram]

Mayya.. joke gaa vesavaa serious gaa vesavaa???

nuv expect chesina result raavatledhu ante how yaa...

nuv pass chese inputs batti ni output untadii...

joke ga veyadanki idi okate naa... naaku asalu aa subject ee radu.. edo ardam kaka esna.. inka emana details ivali andulo ante chepu chepta

[chandra916]

madi oka musthi reporting tool undi mayya.. dantlo feilds extract cheyadanki cff file lo ee code rastamu... deeni ee language coding antaro ipatiki ardam kaledu

ok nenu starting lo python anukunna tharwatha konchem deep ga chusthe python kaadhu ani ardam ayyindhi

[vikuba]

first ee below code ni 

run chesi chudu..

 

select 1 

from cfl, bkg

where 

cfl_res_id=BaseAlias.RES_ID

and cfl_bkg_id=bkg_id

and bkg_start<_ADDDAYS(#END, 1)

and bkg_end>=#START

)

and ConflictHoursDailyOT>0

then 'Y'

else 'N'

end

 

then see if in ur results sets u see appropriate Ys and Ns

[4Vikram]

ok nenu starting lo python anukunna tharwatha konchem deep ga chusthe python kaadhu ani ardam ayyindhi

edo okati mayya.. kncham teliste help cheyi