tag:blogger.com,1999:blog-34020393.post6761306776118438104..comments2024-03-27T10:59:38.307-07:00Comments on Jim's PeopleSoft Journal: Alliance 2009 SessionsJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-34020393.post-54675849725327435272011-10-13T14:35:59.908-07:002011-10-13T14:35:59.908-07:00@Siva, yes. The attachment buttons/links come from...@Siva, yes. The attachment buttons/links come from a derived/work record. You can take whatever action you want when someone clicks the link.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-23615894870981116172011-10-13T10:15:49.105-07:002011-10-13T10:15:49.105-07:00Hi Jim,
Can I have addattachment at level 0 and on...Hi Jim,<br />Can I have addattachment at level 0 and once file gets attached. It should show in grid (level 1). So every time user uploads a file, this grid should get populated with the attached files.<br /><br />Thanks<br />HariSiva Chilukurihttps://www.blogger.com/profile/13548779011498234789noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-81113206786961878052009-03-24T17:15:00.000-07:002009-03-24T17:15:00.000-07:00@Josh, I really hope you enjoyed this session. Ple...@Josh, I really hope you enjoyed this session. Please feel free to post any feedback.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-69587686346102193022009-03-24T09:57:00.000-07:002009-03-24T09:57:00.000-07:00I'm in this session right now!I'm in this session right now!Joshhttps://www.blogger.com/profile/00753974399602277003noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-83278547918727336272009-02-06T03:08:00.000-08:002009-02-06T03:08:00.000-08:00thanks for the help.. I will let you know. once it...thanks for the help.. I will let you know. once its done..Rama Naiduhttps://www.blogger.com/profile/12451232233917358525noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-67562134203965992712009-02-05T12:28:00.000-08:002009-02-05T12:28:00.000-08:00@Rama, don't worry about posting in the right plac...@Rama, don't worry about posting in the right place. Anywhere is fine. It all ends up in my inbox.<BR/><BR/>First off, subrecords are not real records. They are reusable collections of fields. The purpose is to ensure that all records containing that subrecord have the same fields. Therefore, it is not possible to identify a subrecord in the buffer. A subrecord is not a real record. What you really want to access in the component buffer is the main table.<BR/><BR/>Now, if I understand correctly, the question is, "How do I restrict the prompt table rows to only show the 10 to 15 frequently used countries. The easiest way to do this is to replace the prompt table on your subrecord with a view that only shows the countries you are interested in viewing. The problem with this approach is that the subrecord is shared. By changing the prompt table in the subrecord, you will change the prompt table on every record that uses this subrecord, and, therefore, every page that uses that record. Another alternative is to use the <A HREF="http://download.oracle.com/docs/cd/E13292_01/pt849pbr0/eng/psbooks/tpcr/book.htm?File=tpcr/htm/tpcr16.htm#d0e42791" REL="nofollow">Field.AddDropDownItem</A> method. PeopleBooks says this method will override the prompt table and translate table settings. I have not used this method, but this sounds promising. To start with, identify your field in the component buffer using the real, main record, not the subrecord. Next, select your popular rows from the database and iterate over those rows, calling AddDropDownItem.<BR/><BR/>I've never done this before, but if I did, this is where I would start. I hope this helps. Please post your results.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-77199514708383490402009-02-05T10:23:00.000-08:002009-02-05T10:23:00.000-08:00sorry for posting it at a wrong place i guess.. bu...sorry for posting it at a wrong place i guess.. but its kind of urgent..Rama Naiduhttps://www.blogger.com/profile/12451232233917358525noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-21764359103006066442009-02-05T10:22:00.000-08:002009-02-05T10:22:00.000-08:00Hi can you please help regarding below issue,I hav...Hi can you please help regarding below issue,<BR/><BR/>I have a Field "Country" on a page, actually on a subpage.<BR/><BR/>Main Table: A, Subrecord: CM_ADDRESS_SBR, Subrecord: ADDRESS_SBR<BR/><BR/>-> A contains CM_ADDRESS_SBR<BR/>-> CM_ADDRESS_SBR contains ADDRESS_SBR<BR/><BR/>It has COUNTRY_TBL as the prompt table in the subrecord. It gives the entire 200+ countries. Our users want only the frequently used 10-15 countries to be shown in the list.<BR/><BR/>I have to clear the dropdown of this country field to add a few frequently used countries.<BR/><BR/>I tried the 3 ways of below code with the 3 tablenames: (at ADDRESS_SBR.COUNTRY.RowInit)(Have tried at Field Formula also, but no use)<BR/>#############<BR/>Local Field &FLD_ADDR;<BR/>&FLD_ADDR = GetRecord(Record.ADDRESS_SBR).GetField(Field.ADDRESS_DROPDOWN);<BR/>&FLD_ADDR.ClearDropDownList();<BR/>##############<BR/><BR/>None of them worked. I get the error with the 3 tablenames respectively:<BR/>"GetRecord: Record 'ADDRESS_SBR' not found in scroll level 0"<BR/><BR/>So how can I get the field object to clear the dropdown list?<BR/><BR/>Thanks,<BR/>Rama NaiduRama Naiduhttps://www.blogger.com/profile/12451232233917358525noreply@blogger.com