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#goto >> >> 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"