I have a custom list field that is using the native US States list. Whatever value they put in this list will display on the PDF. However, I am having trouble with Alabama. It won't show up. Every other state works. I looked at the internal ID list of US States in NetSuite and Alabam's internal ID is 0. I think this is what is messing things up. I tried a ?has_content and sure enough, Alabama returns as not having content because of the zero int id. I am trying to find some sort of expression in Freemarker that would get it. I can't just default to Alabama because the field may also be blank (which would cause different behavior in the PDF). Any insight or suggestions are welcome.

Not tested, but maybe try

?length == 0

length should be greater than 0 for any real number (even 0), but 0 for an empty string. not sure how nulls are handled, though

Thanks, I tried that. Null and Alabama both came back as a length of 0.

That is unfortunate. It’s ugly, but you could try to specifically detect the case where the value equals 0, and use Alabama for the name in that case, otherwise use the current behavior. Though, I am curious how or why 0 has a length of 0. Is

The internal ID of Alabama is zero. The value of the field is always a state name, not an integer.

Yes, I know. I meant, more specifically, that I’d expect the length of 0 to be, not zero. However, Netsuite has to pass the value to Freemarker, and it may be coming in as a string or a number, though in my experience they are almost always strings. And the string “0” should have a length of 1.

I can't make it distinguish between no selection and Alabama. NetSuite is handing Freemarker an empty string for Alabama. I would log this as a defect Jessica

I wonder if you could try squaring the number? Check if original == original ^ 2 Obv you would also need to manually code whatever internalID 1 is too

All of the values reaching Freemarker are strings, not the numerical id. So can't square them =\