Unnecessary additional query in Filter...

2012-04-18 Thread Joe Martin D'Souza
I found this filter which appears like it may be a part of a filter guide (I haven’t investigated).. If it turns out to be an unused filter, ignore this.. If not I think there is one additional query which is rather unnecessary in this. The Filter Name is INT:AASFND:DAT:Site_Count_Q There are

Re: Unnecessary additional query in Filter...

2012-04-18 Thread Axton
They may be trying to work around inconsistent naming for the database views. Sometimes there are issues with the views being created (ever seen an invalid view in your remedy database?). By using the table (instead of the view) they avoid these issues. The arschema table now has a column that

Re: Unnecessary additional query in Filter...

2012-04-18 Thread Joe Martin D'Souza
Sent: Wednesday, April 18, 2012 3:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Unnecessary additional query in Filter... ** They may be trying to work around inconsistent naming for the database views. Sometimes there are issues with the views being