New answers tagged

2

There's quite a few good ideas/references here, especially to some existing approaches. Often, though not always, Apple's approach is a good place to start - but perhaps in your case it may not be. I get the impression (though you haven't actually said it) that you're working with an awful lot of data comprised of many many fields/variables. I agree that ...


1

It is hard to pin down exactly what is intuitive for something that has traditionally been dealt with by technical users (that won't necessarily find interfaces more user-friend compared to command prompts). There is a particular reason for this efficiency, as queries can be unambiguously specified and executed in a command-line prompt. Also, it probably ...


2

As opposed to re-using pivot tables as I previously answered, this is an experimental UI that I thought of to handle the repetitive need for writing AND or OR. It relies on one element you must learn that ANDs are horizontal and ORs are vertical. It manages to deal with fairly complex Boolean logic though. Overview Assume that A, B, C, D, and E are ...


2

For creating relatively complex single table queries, pivot tables are very useful. Good stuff You can get SUM, AVG and GROUP with relatively little knowledge. By splitting fields across columns vs rows you get AND queries The totals give you OR queries You can properly 'build' queries - i.e. you can quickly see a master set, then add rows / columns and ...



Top 50 recent answers are included