How to filter inquiries by Mailbox?
Hi All,
we have multiple inboxes such as
- sales@
- info@
- ...
I need to filter out all requests, which came in via Mailbox sales@ so that I can count, if all messages were succesfully imported into the system. I tried using the normal filter options, but I cannot filter by "Incoming Mailbox".
How can I filter out all requests, which came in via the Mailbox "sales@" or "info@" into a list?
At the end of the day I just need to make sure that all emails that came in have actually been successfully added to SO. If there is a better way, please let me know.
Alle Antworten (3)
Hi Partick,
First I would like to advise you to look at the mailbox table and find out what ID is linked to each of your desired mailboxes. For this we have a table in the database called "mail_in_filter". You can reach this table by changing URL
YourServiceURL.../scripts/ticket.fcgi?_sf=0&action=searchTable&table=mail_in_filter
When you have an ID of your mailbox, you can add one more criteria to you search criteria list.
You need to add the variable "ticket.filter_id", Example ->
In this example 100240 is an ID of my mailbox that we use in our SuperOffice service. This way I can search for all requests that came to this specific email box.
I hope this helps you to move forward with your task.
Hi Donatas,
I tried your suggestion and found, that the table is not returning anything under "filter_id" - what am I doing wrong?
Best wishes,
Patrick
In mail_in_filter table filter_id = id
I have marked in green the IDs you need to look at 
The next step would be to open your search for your requests and add ticket.filter_id variable as your search criteria 
or you can add a new column with this variable 
