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? -- Fabio Onorini -- [email protected] https://inverse.ca/sogo/lists
