You can apply database filter first time you load the database (not if the database is a delimited file), then that will be saved in model for the next time you open the base. Also via a project.
I had wondered if you could use a Runtime variable calculated field as part of the database filter and just prompt the operator for a value but that looks like a "future wish". So the only thing I can think of right now is the old fallback of multiple models, one for each variation on the filter that you require.
If you then made each of these a project the users could simply load the 'Weekly' project or the 'Monthly' project and so on.
If you go that route (assuming I have got your requirement right) I would make the database filter the last part of the model build - i.e. after you hve developed all of the internally used filters, calculated fields and so on. Much less work that way! Just save the models/projects with different names according to the database filter.
Alternatively if you did the database filters first and set up the multiple models, Workstore might be a useful investment.
Hope this helps a little.
Is there a way to save and edit the apply filter function when working with a database in Monarch Pro 7.0? I want to do the same query on a daily, once a week, or monthly time frame but be able to edit the filtering to cut down on user intervention and response time.
I know I can create a model to filter after I have selected the database and tables I need, however I like to use later filters for other purposes. The apply database filter reduces my "crank" time. /b[/quote]
[size="1"][ January 27, 2004, 08:33 AM: Message edited by: Grant Perkins ][/size]
I am not sure how to set up a runtime variable but will investigate that further. Yes, the filter does save if a project but it becomes a static database at that point. Filtering after the database is brought into a Monarch table is very time consuming since I can't edit the filter until the table is populated. For small databases that is fine but with such things as account detail even with a fast pc and database repository I can grab a few winks. Workstore sounds like another application to learn.