Headed List Function needed

Doug Easterbrook doug at artsman.com
Thu Jun 3 15:01:12 UTC 2021

hi Mike:

Brian pointed out that it can be done.

but to me, what you ask borders on an programer implementation/feature problem, not a root omnis problem.    

we implement also implement column searches on headed lists.   I put a popup of the fields to search by.       They are all in a subwindow

currently the search goes against the database by adding a where clause, but it wouldn’t be hard to wire ins something that searches the column in the list and shows different values in the column.    

A subwindow would give you a GENERIC widget that you could apply to any headed list and then have the implementation the way you wanted.

I compare what you are trying to do 0— to be similar to totals in a headed list.   Yes we do this manually …. yes Omnis has a feature for that ….  I’m not a fan of the look of how it was implemented.

I think omnis should provide based functionality in the window, like drag columns, drop files, clicking on headers, all that stuff.

the action that is taken from the drag column, drop file, header click is all up to the programmer who needs to provide their own code for the action .. and over ride it if necessary.

in the case of what you suggest, a headed list with a companion filter subwindow  — is all that is needed to do an implementation of specific features that you might want — in a way that you can customized, perhaps on field type or what have you.  you could use filters, or just read the list to get distinct  (which you can get with a list.$cols.$removeDuplicates or something like that).

just an opinion.   

I know it is hard to spearate what the tool should do and what we should do..        subwindows and inheritance help, imho.

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
Phone (403) 650-1978

> On June 3, 2021, at 6:31 AM, Mike Matthews - Omnis <omnis at lineal.co.uk> wrote:
> Hello All,
> In Excel, you can add a dropdown Filter that shows you all of the different values in that column.  You can then choose to only show selected values, ie, where rows = ‘123’, etc.
> That would be nice for Studio I think, so you don’t have to build a DISTINCT list of values in a column, so you add your own DropDown list filter.
> Has anybody done this, before I ask the Carlton House team to see if could be done?
> Thanks
> Mike Matthews
> Lineal Software Solutions
> Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>
> omnis at lineal.co.uk<mailto:mike.matthews at lineal.co.uk>
> www.lineal.co.uk<http://www.lineal.co.uk/>
> www.sqlworks.co.uk<http://www.sqlworks.co/>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

More information about the omnisdev-en mailing list