tag:blogger.com,1999:blog-4007772006737635792.post8265057608859970749..comments2024-03-27T16:11:52.332+05:30Comments on Shyam's Blog | Oracle Cloud, Peoplesoft, Workday: Code to custom sort a PeopleSoft Drop-down ListShyamhttp://www.blogger.com/profile/08146888311621138779noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-4007772006737635792.post-82804144543041022942014-05-05T15:07:24.296+05:302014-05-05T15:07:24.296+05:30I am running a Application Engine, each time i run...I am running a Application Engine, each time i run it, already inserted values should be flushed out and only newly inserted values should be available in the record. please help.Anonymoushttps://www.blogger.com/profile/05491027623505015478noreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-72973231891127618822014-03-19T16:41:05.695+05:302014-03-19T16:41:05.695+05:30I wrote the above piece of code in Page activate.I wrote the above piece of code in Page activate.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-70652973869748430322014-03-19T16:03:45.507+05:302014-03-19T16:03:45.507+05:30HI I have tried the below code.
Local Rowset &...HI I have tried the below code.<br />Local Rowset &Xlat;<br /><br />&FLD = GetRecord(Record.BP_WORKLIST_WRK).GetField(Field.BP_TO_VERSION);<br />&FLD.ClearDropDownList();<br /><br />Evaluate %Component<br />When Component.BP_COPY_VERSION<br /> &Xlat = CreateRowset(Record.PSXLATITEM);<br /> REM &Xlat.Fill("WHERE FILL.FIELDNAME = 'BP_TO_VERSION' AND Fill.FIELDVALUE in ('1','2') and FILL.EFFDT = (select max(B.EFFDT) from PSXLATITEM B where B.FIELDNAME ='BP_TO_VERSION' and B.FIELDVALUE in ('1','2') and B.EFFDT <= FILL.EFFDT)");<br /> &Xlat.Fill("WHERE FILL.FIELDNAME = 'BP_TO_VERSION' and FILL.EFFDT = (select max(B.EFFDT) from PSXLATITEM B where B.FIELDNAME ='BP_TO_VERSION' AND B.FIELDVALUE=FILL.FIELDVALUE and B.EFFDT <= %CurrentDateIn)");<br /> rem &Xlat.Fill("WHERE FILL.FIELDNAME = 'BP_TO_VERSION' and FILL.EFFDT = (select max(B.EFFDT) from PSXLATITEM B where B.FIELDNAME ='BP_TO_VERSION' AND B.FIELDVALUE=FILL.FIELDVALUE and B.EFFDT <= %CurrentDateIn) AND FILL.EFF_STATUS='A'");<br /> &Xlat_cnt = &Xlat.ActiveRowCount;<br /> MessageBox(0, "", 0, 0, "ActiveRowCount = " | &Xlat_cnt);<br /> &Xlat.Sort(PSXLATITEM.FIELDVALUE, "A");<br /> For &I = 1 To &Xlat_cnt<br /> &CodeIn = &Xlat.GetRow(&I).GetRecord(1).FIELDVALUE.Value;<br /> &DescIn = &Xlat.GetRow(&I).GetRecord(1).XLATLONGNAME.Value;<br /> If &CodeIn <> BP_WORKLIST_WRK.BP_BUDGET_VERSION Then<br /> &FLD.AddDropDownItem(&CodeIn, &DescIn);<br /> End-If;<br /> End-For;<br /> <br /> Break;<br />When-Other<br />End-Evaluate;<br /><br />But still i dont see values sort in correct order. in PIA when i check i see dropdown showing values like <br /><br />Base,Master,Version 10,version 11,version 12,version 13,version 14,version 15.......version 19,version 2, version 21, version 22........version 29,version 3, version 31,version 32....version 35,version 5,version 6,version 7,version 8.......<br /><br />in App designer i have set my translate field in correct order like <br /><br />Value - Long name <br />0 - Base<br />1-version 1<br />2-version 2......<br />A - Version 10<br />B - Version 11.....<br />z - version 35....<br /><br />Request for any inputsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-20953933101393331462014-03-18T12:46:12.261+05:302014-03-18T12:46:12.261+05:30Hi
I have an issue with the translate field To ver...Hi<br />I have an issue with the translate field To version. I got a Bug where customer is having this issue:<br />I have one translate field which is character type and is placed in one work record.I have added values to the translate field like <br />Value : Longname <br />1 Version1<br />2 Version 2<br />3 version 3....<br />9 Version 9<br />A Version 10<br />B Version 11 <br />C Version 12...<br />J Version 19..<br />Z version 35<br /><br />When my customer select the version field which is dropdown he is able to see values like <br />VERSION 10<br />VERSION 11<br />VERSION 12<br />VERSION 13.....<br />VERSION 19<br />VERSION 2<br />VERSION 20<br />VERSION 21...<br />VERSION 29<br />VERSION 3<br />VERSION 31<br />VERSION 32...<br />VERSION 35<br />VERSION 5<br />VERSION 6<br />VERSION 7<br />VERSION 8<br />VERSION 9 which is incorrect order.<br />Now customer is requesting for order to show like<br />VERSION 1<br />VERSION 2<br />VERSION 3.....<br />Please do the needfull. Request to share inputs to my mail id : ravi.velchuri38@gmail.com. Thank you.<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-77183533776801943632014-03-18T12:30:03.981+05:302014-03-18T12:30:03.981+05:30Anyone can help me where to write this code and in...Anyone can help me where to write this code and in which event??Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-63453971681300693612010-09-27T23:51:29.176+05:302010-09-27T23:51:29.176+05:30Shyam this worked great... Thanks!Shyam this worked great... Thanks!Dallasnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-29512166300821277852010-05-21T03:30:25.363+05:302010-05-21T03:30:25.363+05:30This comment has been removed by the author.KKhttps://www.blogger.com/profile/16010475357838842216noreply@blogger.com