SELECT
	scriptid,
	name,
	fieldtype,
	fieldvaluetype,
	BUILTIN.DF( owner ) AS owner,
	lastmodifieddate
FROM
	CustomField
ORDER BY
	scriptid, fieldtype

This custom field query, I'd like extend to filter where the fieldtype is COLUMN but failing miserably, I tried:

WHERE CONTAINS(fieldtype, 'COLUMN', 1) > 0

to no avail. Does anyone know if it's possible also to filter based on the record type it's assigned to, for instance "Purchase" or the value of the property if not? I think it's a specific field per record set as per the UI whihc the XML implies is "colpurchase"...

if fieldtype is a string, did you try LIKE operator?

my goto is to build the basics of the query in the analytics ui, save it, then use Query.toSuiteQL to inspect the suiteql that netsuite generates

I did try LIKE to no avail thank you for the suggestion @Dmitry Masanov. I'll look in to the analytics UI@battk it's not something I've been near before! Thanks both for replying.

SELECT

scriptid,

name,

fieldtype,

fieldvaluetype,

BUILTIN.DF( owner ) AS owner,

lastmodifieddate

FROM

CustomField

WHERE

fieldtype = 'COLUMN'

ORDER BY

scriptid, fieldtype

@DMS Thank you for this. I'm not sure where I went wrong, I feel sure that's how I'd filtered it, shame I didn't keep my query!