search by db-id in UI

General discussion about Zimbra Desktop.
Post Reply
heiko.robert
Posts: 5
Joined: Wed Aug 31, 2022 2:54 pm

search by db-id in UI

Post by heiko.robert »

How could I search by zimbra's message-db-id? In https://wiki.zimbra.com/wiki/Zimbra_Web ... earch_Tips I found

Code: Select all

  message:(DB_MSG_ID)
but when I take the id from a cli search like

Code: Select all

zmmailbox -z -m me@mydomain.org s -t message -l 1000 "in:Inbox subject:\"Your password is expiring\""
        Id  Type   From                  Subject                                             Date
    ------  ----   --------------------  --------------------------------------------------  --------------
 1. 438375  mess   helpdesk              Your Password is expiring in 11 day(s) at 31.05.20  05/20/23 06:47
searching for

Code: Select all

message:438375 
does not return any message.

Any hint?
Klug
Ambassador
Ambassador
Posts: 2746
Joined: Mon Dec 16, 2013 11:35 am
Location: France - Drôme
ZCS/ZD Version: All of them
Contact:

Re: search by db-id in UI

Post by Klug »

heiko.robert
Posts: 5
Joined: Wed Aug 31, 2022 2:54 pm

Re: search by db-id in UI

Post by heiko.robert »

what do you mean? Which mysql version? It's a 5.5.39 but I guess my question is more lucene related when searching in the zimbra's UI?
Klug
Ambassador
Ambassador
Posts: 2746
Joined: Mon Dec 16, 2013 11:35 am
Location: France - Drôme
ZCS/ZD Version: All of them
Contact:

Re: search by db-id in UI

Post by Klug »

Read the link I gave: accounts are stores in "mailboxes groups" in mysql, there are up to 100 mboxgroups per server.
So the first thing you have to do is to get the mboxgroup of the account you want to search "in", and use it as selected database in mysql.

However, this is of ZCS, not zDesktop. But anyway you'll have to use the proper DB.

Edit a bit later: I misread your first post, sorry (read it too quickly).
I didn't see you were trying to do a search in the WebUI.
mitesh.savani
Zimbra Employee
Zimbra Employee
Posts: 13
Joined: Wed Oct 19, 2022 6:05 am

Re: search by db-id in UI

Post by mitesh.savani »

Can you try searching for a message with the "conv" search keyword as like below. You need to put "-" (minus sign) before message id.

Code: Select all

conv: "-438375"
Post Reply