Discussions
DECODE Function on Customer Search
Hi all,
I'm testing out using the DECODE function on a customer search. I have a custom integer entity field created on customer records called "Integer Test" (custentity3). I created a few test customer records and input "1" into this field. (This field will either contain a 1 or 0 which I am trying to show as T or F, respectively in search results).
I created a customer search with the criteria of looking for any customer record with a "1" in the Integer Test field. It successfully returns the two test customer records I created.
In the results field, I want to use the decode function to display T or F in the results instead of the 1 or 0 that is stored in that field. This is where I'm getting confused as to how to use it. I've added a result - Formula (Numeric). In the function column, I've attempted to use the DECODE function but keep returning errors when I view the results. Here is what I'm using: