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:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, June 20, 2012 6:54 AM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, June 20, 2012 3:52 AM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky >> Sent: Tuesday, June 19, 2012 8:34 AM >> To: arslist@ARSLIST.ORG >> 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#got >> 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"
