Hi, Some years ago I had a similar problem in ARS 7.1. The answer was: "works as designed" and they created a defect to correct the manuals. But I never verified if BMC modified their manuals.
SW00301166 -- Doc bug: Server Side Table loop requires access permission on supporting table form REF ARS 7.1 Worfklow Objects Pg15 KR Conny -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von Misi Mladoniczky Gesendet: Mittwoch, 20. Juni 2012 19:51 An: [email protected] Betreff: Re: Filter Table Refresh differ if Admin User... Hi, I missed this feature too... I usually read the release notes quite thoroughly, but I did not see this. Which version was it introduced? RRR|Log does not strip out anything from the logged lines, but in this case I checked the setting for Data Access -> Get Data As, and it is set to "System", not "User". So it seems like this is actually a bug then... AR System 7.6.04 SP2. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Fred, > That is an interesting feature I didn't know existed.... > > Misi, > A few choice notes from the workflow guide, page 303 > > Workflow Functions > In addition to the Set Fields, Push Fields, and Call Guide actions, > setting Get Data As to User affects the workflow functions COLCOUNT, > COLAVG, COLMIN, and COLMAX. > These functions operate over the columns in a table field. When > performed in a guide that was called by a filter with the Get Data As > User set, the entries and fields used to populate columns in the table > field are limited to those visible to the calling user. > > And almost more importantly > > Filters with Get Data As set to User are identified in the filter log > file by the string "with data retrieval as user userName." > > So...being all we have access to is your RRR|Log parsed > portions....did this text display in the filter log? Is the filter in > question set with this restriction? > > If your answer to either of those questions is No...then we have a bug > somewhere...I don't recognize 'MOB'...is that a custom application? > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Grooms, Frederick W > Sent: Wednesday, June 20, 2012 6:54 AM > To: [email protected] > Subject: Re: Filter Table Refresh differ if Admin User... > > Actually if you look at a filter in Developer Studio 7.6.04, in the > Properties you will see > > + Change History > - Data Access > Get Data As > + Full Text Search > + Help Text > + Integration Workflow > > And the choices for Data Access are: System | User > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Misi Mladoniczky > Sent: Wednesday, June 20, 2012 3:52 AM > To: [email protected] > Subject: Re: Filter Table Refresh differ if Admin User... > > Hi, > > It turned out that if I changed the permission on the table and > underlying join form, the table got refreshed. > > This definitely seems like a BUG, as filters should ALWAYS run with > administrator privileges... > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP > 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > >> Hi LJ, >> >> Thank you for the input. >> >> In this specific case, the table is never refreshed. >> >> And I am not doing a table loop, just a Set-Fields with a COLSUM(). >> >> And the really strange thing is that the behaviour differ depending >> on the users permission groups... >> >> I agree that there is need for more control over the filter tables! >> >> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP >> 2011) >> >> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy >> logs. >> Find these products, and many free tools and utilities, at >> http://rrr.se. >> >>> Misi, >>> I can't speak directly to your situation, but I have seen in the >>> past that server table loops don't necessarily refresh the table >>> every time you do something with them...I have done loops before >>> where the table has a dynamic qualification, and you set the field >>> that makes it dynamic, then utilize the table...then within the same >>> transaction, you change that qual, and try again and it doesn't >>> necessarily refresh the table even though the qual, and thus the >>> contents should change. Without a 'refresh table' option in >>> filters, I've never quite been sure how to get it done. >>> >>> -----Original Message----- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[email protected]] On Behalf Of Misi Mladoniczky >>> Sent: Tuesday, June 19, 2012 8:34 AM >>> To: [email protected] >>> Subject: Filter Table Refresh differ if Admin User... >>> >>> Hi, >>> >>> I have a 7.6.04 SP2 system, where I am having inconsistent behaviour >>> in filters depending on if you are an Admin user or not. >>> >>> This is an outline of the stuff involved 1. API Call Create Entry 2. >>> Filter makes Service Call 3. Filter performs a Set-Fields from a >>> Table Column, which should always trigger a table refresh >>> >>> This is the same workflow as non-admin user, followed by an >>> admin-user >>> (Demo): >>> http://rrr.se/tmp/rrrlog-service-table-refresh-problem-nonadmin.html >>> # >>> goto >>> http://rrr.se/tmp/rrrlog-service-table-refresh-problem-admin.html#go >>> t >>> o >>> >>> I have some times seen strange behaviour inside of >>> filter-service-calls. >>> This could be related to that. >>> >>> How is a person to make sure that tables in filters are refreshed >>> properly? >>> >>> Any comments? >>> >>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP >>> 2011) >>> >>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): >>> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy >>> logs. >>> Find these products, and many free tools and utilities, at >>> http://rrr.se. > > > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
