Skip to main content
Closed

Filter based on custom field

Related products:Freshdesk
  • Aug 18, 2014 1:12 AM UTC
  • 14 replies
  • 73 views

 I would like to filter based on a custom field using the API. The same was asked in this thread but it is now closed: https://support.freshdesk.com/support/discussions/topics/40850

14 replies

  • Community Debut
  • Mar 16, 2015 1:24 PM UTC

This is a much needed feature. Without it, custom fields aren't as useful!


  • Community Debut
  • Dec 12, 2015 11:49 AM UTC

Hi Freshdesk any update upon this ?


  • Community Debut
  • Dec 14, 2015 1:34 AM UTC

 Hi Freshdesk any good news about this request ?


would be invaluable. Any project on this?


  • Community Debut
  • May 4, 2017 4:40 PM UTC

Would really like this for contacts GET method as well


  • Community Debut
  • May 5, 2017 7:52 PM UTC

We're having to now move all these custom fields over the FreshSales to manage them there, and then do a sync.  It's clunky and awful to manage.  It would be so much slicker to just be able to have that FreshSales functionality in FreshDesk.  Seems a little ridiculous that it doesn't. 


  • Community Debut
  • May 12, 2017 4:26 PM UTC

We use a custom field to store a "customer ID". In our CRM database this ID is the unique key for a customer. We need to be able to use the contact endpoint to search and retrieve a contact based on their ID.  Is this possible yet? 


 

It would be so nice to just be able to have this FreshSales functionality in FreshDesk.  It's about time, it would definitely make things a lot easier to manage.



aravind.sundararajan
Skilled Expert
Forum|alt.badge.img+12

Hello Folks,


Happy to let you know that we've the filter tickets API using which you can now filter for tickets using custom field data. Here's the magic link to the documentation .


Cheers!


this is implemented in the API but not in the UI.


  • Community Debut
  • Sep 26, 2018 7:56 AM UTC

This is much needed through UI too. I can not understand it is not yet possible. Thanks.


  • Contributor
  • Dec 4, 2019 7:24 PM UTC

I cannot get this to work with custom fields:


It returns no results but the field is there... here is the get request:


curl -v -u fresh-desk-server@xxxx:yyyy -H "Content-Type: application/json" -X GET 'https://catprint.freshdesk.com/api/v2/search/tickets?query="cf_orderid:B191204_672632"'


this returns no results, but there is indeed a ticket with OrderId: B191204_672632


What am I doing wrong???


FYI I have tried various combinations such as removing the cf_ (that is not documented but seems necessary) adding / removing quotes (%27) around the string, etc.



I also searched for the same ticket using other criteria and I see the fields are there. This is a partial json of the return of the search


"custom_fields":{"cf_internalorderid":123456,"cf_orderid":"B191204_672632"}


Finally I tried changing to a number field (cf_internalorderid) and it also does not work.



  • Community Debut
  • Dec 11, 2019 6:11 AM UTC

Hi 

I am also facing the same issue as Mitch has mentioned

below doesnot return any data, but there is definitely ticke with customer_id = 5788394511

https://freshdesk011help.freshdesk.com/api/v2/search/tickets?query="cf_customer_id:5788394511" 

Don't know is it because i am using trial account?


  • Contributor
  • Dec 16, 2019 7:10 PM UTC

I did not work for our account even though it was not a trial. They had to switch some feature on to make it (sort of) work.