https://bugs.documentfoundation.org/show_bug.cgi?id=138715
--- Comment #34 from Alex Thurgood <[email protected]> --- (In reply to Robert Großkopf from comment #33) > SELECT "a"."card", > "a"."value" "DisplayName", > ( SELECT "value" FROM "properties" WHERE "card" = "a"."card" AND "name" = > 'PrimaryEmail' ) "PrimaryEmail", > "lists"."name" "list" > FROM "list_cards", "properties" AS "a", "lists" > WHERE "list_cards"."card" = "a"."card" AND "lists"."uid" = > "list_cards"."list" AND "a"."name" = 'DisplayName' Thanks for the suggestion, but that query returns no results for me with abook.sqlite, probably because that file has no data in list_cards or lists, and the NULL resultset is ignored. In Thunderbird, my personal addressbook shows something like 857 entries. I don't know why lists and list_cards would be empty, whereas properties isn't. -- You are receiving this mail because: You are the assignee for the bug.
