Report Initial Filters
When I go into a report to change filters such as: Date Modified is On or after 100 days in the past by changing the "Select a field.." option it resets the conditions and anything in the last input ...
Forum Discussion
I understand what you mean and have been frustrated by this in the past when I am updating a report to new filters and forgot what was in there previously. When switching it you can sometimes forget and end up with a different report than you intended. This is rarely an issue for me though as I try and "Set it and forget it" with reports the best I can.
If you are finding yourself always needing to update some of these reports to see different things then either you need to use more reports or you should make use of the <ask the user> function more. You can even do this while having multiple fields like you mentioned where Customer Name would be blank but they enter John into Customer Contact instead and it filters for that.
If you are finding yourself always needing to update some of these reports to see different things then either you need to use more reports or you should make use of the <ask the user> function more. You can even do this while having multiple fields like you mentioned where Customer Name would be blank but they enter John into Customer Contact instead and it filters for that.
- MarkShnier__You
Qrew Legend
I agree with Austin in that yes this is the expected behavior, and its not a bug but it is very frustrating and can 'bite' you from time to time if you are not right on your toes. I have had situations where I am editing a complex set of filters and have to bail out before saving because I realized I just lost the information as to how the previous filter was set, so I had to stat over and pay closer attention.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Jeff,
On many more than one occasion....
So as a "rule" I now edit the filters and Display the report, I do not Save it until I have got everything fleshed out.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------ - I was unsure of how to characterize this issue, as a bug or as a question of practice. As a software engineer though I think this is fixable issue and it really is an issue because its very easy to do this wrong and lose information and can impact people's business case. I appreciate the quick response.
Thanks
------------------------------
Jeff Rohan
------------------------------- MarkShnier__YouI imagine that in practical terms it may not be a simple fix. Suppose you have a text field and then you change the filter so as to on a date field where it was previously filtering on a text field. The type of words they get offer up for the match conditions will be completely different for date fields versus text fields.So I think rather than the program comparing the field type of the old field you were using compared to the new field you are using, to detect that it is the same field type and hence to preserve the filter conditions, they just treat it as a reset and start fresh with the correct comparative operators for the field type that you have selected. So I think they will consider that to be an enhancement request and not a bug.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
