Adventures in WhatsApp DB – extracting messages from backups

So we can search for a contact by name or phone number or search for a specific conversation by messages if we remember part of the text and eventually extract the complete conversation based on the conversation ID. First let’s find a conversation we care about, such as by looking for a specific phone number:
a fragment of the phone number is enoughyou should notice that the lambda I created is used to search both the from and the to columns. Anyways, moving on if we look at the ZCHATSESSION column we’ll notice that in my case the conversation id will be “104.0” for this number (if there are also group chats you may see more than one chat session id).

Source: medium.com