| Author |
Message |
    
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3444
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:57 pm: |    |
amayya happy ga aa xls file ni director ki pampinchi dobbutha inka. ivvala 10 ki bayata ki poyi 3:15 ki office ki vacha. saana work pending padindi  |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3443
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:56 pm: | |
kiki
and workflowstateid ! = 17 anna.
17 = not ready. aa rendu rows ethi dobbindi. saalu inka. kummesio. |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3442
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:54 pm: | |
ippduu ee stateid unte choyinchodhu antaniki elagabha |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3441
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:53 pm: | |
ok ardamaipoyindi. basic gaa ee nakoduku ee stage lo unna 2 times not ready ane status tho 2 records create chesi dobbuthunnadu. so aa rendu peeki dobbali. migilina rendu manchi states. avi display chesthe chaalu. eyy eyy. vachesindi. kaani aa rendu ela peekalo chodali inka.
thanks gochi mama, timestamp ante anni columns chostham start chesa. kiki. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 43671
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:52 pm: | |
nee yenks eee kaadiki oka theddu esi DB server meedha load penchindi kaaka,naa 15mins billing time waset jesthaava 
school kelli sadavaledu 123....ninnu choosi nerchukunna 143  |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3440
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:49 pm: | |
chass. comedy ga
okadu expense report create chesadu anthe. draft lo undi. kaani daniki states 4 choyisthundi.
Not ready
Not ready
draft
not submitted
appudu annitiki oke time stamp untundi. denemma oka stage ki inni states endehe karma. so ee nalugu unte draft okkate choyinchamanta. idi bagundi. ento naalo nene mattadukuntunte idea vasthundi. kiki. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 43669
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:48 pm: | |
 nee yenks edo oka timestamp/status date untundhi soodu....alaaa unte aa date ni patti recent record laageyyocchu..
Query ilaa raasesko....
SELECT max(Table_name.column_name) keep (dense_rank first order by status_date desc) "Column name",
etc etc
from .....
eee query endante basic gaa aaa tablelo unna records ni by date rank chesi,top rank dhi pick chesthunnavannamaata 
school kelli sadavaledu 123....ninnu choosi nerchukunna 143 |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3439
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:42 pm: | |
nenu where condition lo ekkado bokkettinattunna. aagu chostha. ee lopu pai danni max(stateid) ela vadalo evaranna cheppandi. |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3438
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:41 pm: | |
modified timestamp okate sooyithundi enti comedy ga. edo jarigindi. nee idea bagundi gochi mama. kaani timestamp anni rows ki okate undi. |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 43668
Registered: 07-2004
Posted From: 71.234.247.143
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:36 pm: | |
aaa stages ki link aina Date/timestamp emanna undhaa hemu maama 
school kelli sadavaledu 123....ninnu choosi nerchukunna 143 |
Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma
Post Number: 3437
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, July 31, 2007 - 6:34 pm: | |
ippudu oka expensereportstate ane table undi. prathi expense report ki different states untayi. like draft, submited for management approval, waiting audit approval, approval complete. ala ippudu aa states anni vere tables lo
1-> draft
2 -> submitted for management approval
3-> waiting for audit approval
4-> approval complete
ani define chesi undi.
ippudu nenu select x, y from expensereportstate ante anni states unna records vasthunnayi. suppose adi 3rd stage lo aagithe aa 3 stageski 3 records vasthunnayi. ala kakunda max stage unna record okkate ravalante elaa rayali query? |
