Take the 2-minute tour ×
User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It's 100% free, no registration required.

I have very amount of complex interdependent data, such as products, documents, orders. I need to make expression-builder for selecting and filtering(!) data.

I have some ways to do this

1) I can make plain editor based on SQL language. Simple text field. Nothing else. In order to do filtering I can introduce keyword such as "FILTER" But I suppose that this method is bad UI.

2) I can make 3 columns: data field, condition, value.

Using this user can write these conditions Product.Price > 20 Product.Name = "Salt"

I believe that this method is better than previous, but if I choose this way how can I make filtering?

Is there third method?

share|improve this question

2 Answers 2

up vote 3 down vote accepted

I made it like this:

enter image description here

So the users can read the filters like normal sentences, but they don't have to type so much, because everything is a dropdown.

enter image description here

share|improve this answer

There are two more way to filter the data.

  • Autofilters -- like in Excel or Google Spreadsheet. It requires minimum effort for most filtering tasks and familiar to an average user. Advantages are minimal input and obviousness.
    enter image description here
  • Templates -- most frequent filtering tasks could be called through command buttons as one-click task. It convient for some narrow filtering tasks (i.e. filter today's operations etc.).
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.