How to filter inquiries by Mailbox?

lock
push_pin
done
Besvaret
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. okt. 2023 | 11.50 AM

Alle Svar (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

Tilføj svar