Understanding Custom Text Fields in Bullhorn Reporting (Previously Canvas)

Sometimes when you have a custom text field in use that's taking advantage of both a Value List and Display Value List in Field Mappings, you will need to modify your filter in Bullhorn Reporting. This article covers how to filter by a custom text field value.

Steps

For example, let’s say you are looking to filter on a customText field you’ve labeled "Market" and you want to see what’s going on in the Western market. But filtering by “West” results in nothing showing up in your report. Follow the steps below to correct this.

1. From your Bullhorn Menu, select Field Mappings.
   • S-Release: From your Menu, navigate to Tools > Field Mappings
     
     
2. Expand the entity where your field is located. For example, the Job entity.
3. Filter the Label field by typing in "market" and click on the customText field.
   
   
4. Here you can see the following:
   
   
   • Value List: 1,2,3,4
   • Display Value List: East, West, North, South
     
     
   
   
5. Your filter needs to search for the values in the Value List. Modify your filter to look for 2 instead of West and your filter will work.

For more details on advanced filters, see Creating Advanced Filters in Bullhorn Reporting (Previously Canvas). For more details on the Display Value, see Filling in Custom Field Details.