I would, for example, make search on all email address of contacts or phone numbers.
Now with the webmail I can search only in "_quick" fields, so I can't use secondary mail or other fields for contact filters. I could search directly on carddav content but I think is slow search and no specific field searching. I would strip carddav attribute names and save a BLOB field with only values, for a full test search. 2015-01-12 15:08 GMT+01:00 Christian Mack <christian.m...@uni-konstanz.de>: > Hello Fabio Onorini > > Am 2015-01-07 um 16:28 schrieb Fabio Onorini: > > Now sogo use 3 tables for every calendar/addressbook folder. > > > > The main table contains ICS/VCF data, _quick table contains principal > data > > and _acl table that contains perms. > > > > If I need to filter records using structured data, I must use quick > table, > > but I can't use all data. > > For example, that table contain only one telephone attribute, or email > > attribute... > > > > There is way to strip ics/vcf tag and save only values in a BLOB field > and > > use it for searching? > > Or extend methods that save data form ics/vcf to quick? > > > > I think also to use TRIGGERS on table, but I must reanalize ics/vcf, so I > > must call script from DB. > > > > Any ideas? > > > > Sorry, but what do you want to achieve? > Could you use a view for that? > > Kind regards, > Christian Mack > > -- > Christian Mack > Universität Konstanz > Kommunikations-, Informations-, Medienzentrum (KIM) > Abteilung Basisdienste > 78457 Konstanz > +49 7531 88-4416 > > -- Fabio Onorini -- users@sogo.nu https://inverse.ca/sogo/lists
