BS&A Software Blog

In order to pull specific data out of the Building Department program (tables, reports, Excel spreadsheets, or charts), it is necessary to run a filter.

Creating a filter is the program’s way of sifting through ALL of its records and displaying ONLY the info you need. Think of a filter as a sieve: it lets some information through while blocking out the rest.

Applying a filter has the same look and feel in every area of the program. The first tab shows “common” report filters and gives the most used options for a given table. The second tab shows more advanced filter options, allowing you to pull more detailed information or data from other sources (depending on the nature of the filter).

Edit Filter Condition gives you the ability to change the operator for a given value: Equals will show only records that match exactly; Not Equals will show all records BUT that value; Between allows you to pull a range of information (effective for dates); Starts With will pull only records that begin with the value (very useful when searching by record number); and so on.

On the Advanced Filter Options tab, you can also change the adjoining operators from ALL to ANY to control what the filter must match for more control over the data you receive.

When you have created a filter, you can save it to your database to use again later. The filter can be loaded from anywhere in the program, saving you time and allowing other users to view the same results.

While simple filters are generally easy enough to input and understand, more advanced filters can pose difficulties. If you are filtering data and receiving “No records exist” messages, it is possible that a condition or operator is incorrect. Please feel free to contact tech support for assistance.

Posted in: Community Development

Views: 7563

Interested in learning more?

Get in touch and we would be happy to schedule a detailed overview of our solutions. 


Why use BS&A Software?

We actually listen. Some of the most useful features we have in our software came through suggestions from you. If you keep talking, we’ll continue to listen.

See more reasons

I take my hat off to the support staff, I cannot imagine doing their job with so many variables between units of government and seemingly constant change from Lansing. Also to the programmers who always find a way to help us out, not to mention everyone else at BS&A. I cannot say enough good things about or express my appreciation to Dan Kirwin, he has conducted educational classes many times in my county in the last 10 or so years and never once have I heard anyone being disappointed. I always attempt to host a STC renewal class here ...

Continue Reading »

Greg Hill, Equalization Director

Need help finding the right software solution?

We’ll help you find the software that fits your needs. Get in touch with our team to get started.

Get in Touch

Software Support & Training

Your resource for everything you need to learn about your software. Can’t find what you’re looking for? Get in touch for support.

Featured Tutorial

Check out our learning center for more videos
Employee Self Service

Employee Self Service

Employees can view prior checks, request changes to personal employment information, check leave balances, etc.

Added in AccessMyGov

Have questions or want to learn more about our software? We’re here to help! Feel free to

Get in Touch