Any idea what can be wrong with the query below? I want to extract all entities but mask Employee data. However

type

filter does now work at all. It always returns the

entityid

SELECT 
  E.type, 
  E.id,
  E.isinactive,
  CASE WHEN E.type = 'Employee' THEN 'Masked' ELSE E.entityid END AS "Name"
FROM entity E

@Selcuk Dogru Try using the BUILTIN.DF function, like this:

SELECT
  E.type, 
  E.id,
  E.isinactive,
  CASE WHEN BUILTIN.DF( E.type ) = 'Employee' THEN 'Masked' ELSE E.entityid END AS "Name"
FROM entity E

thanks @tdietrich, that was the trick

It's confusing, I know. But I think that behind the scenes the entity type is actually stored internally as an integer. The BUILTIN.DF function does the translation. Where it gets confusing is that we don't seem to be able to see the entity type value as an integer. In other words, I think SuiteQL is automatically handling the conversion from the numeric to varchar value.

well, at the end what we see is the DB views, we can assume many things 🙂

Agreed. There's a level of abstraction that SuiteQL imposes, and it isn't always apparent that this is happening. It would be nice to get to the raw data - and to be able to create our own views as well.