How to filter inquiries by Mailbox?

lock
push_pin
done
Answered
4

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. 

5 Oct 2023 | 11:50 AM

All Replies (4)

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.   

20 Nov 2023 | 08:04 AM

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 

27 Nov 2023 | 12:36 PM

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 




5 Dec 2023 | 07:52 AM

test

12 Mar 2024 | 06:35 AM
12 Mar 2024 | 06:45 AM

Add reply