Anyone know a clever way (without N/record loading...
# suitescriptd
dcrsmith
07/18/2022, 11:22 PMAnyone know a clever way (without N/record loading record) to find what custom fields are on the record? (assume you don't know the record)
b
battk
07/18/2022, 11:27 PMCustomField query
d
dcrsmith
07/18/2022, 11:28 PMYah, got that far. But I can figure out if it's on a Sale Order or some other record type.
dcrsmith
07/18/2022, 11:29 PMThe "applies to" is not exposed
b
battk
07/18/2022, 11:37 PMthe easiest is basically what you dont want to do, use N/record to create a record
battk
07/18/2022, 11:37 PMthen get the fields from it
d
dcrsmith
07/18/2022, 11:38 PMYah, but performance can really suck in that case. I know I can do that but I REALLY don't want to.
b
battk
07/18/2022, 11:42 PMim not really sure what makes that slow
battk
07/18/2022, 11:43 PMbut i guess the similar query alternative is a select * using suiteql
battk
07/18/2022, 11:44 PMand hopefully add whatever condition and table is necessary to limit the results to your particular type
d
dcrsmith
07/18/2022, 11:46 PMI'm tempted to just use jQuery and get the xml=t
m
michoel
07/18/2022, 11:47 PMIf you are client-side you can call the records catalog internal endpoint
d
dcrsmith
07/18/2022, 11:48 PM@michoel example? Not sure what you mean.
m
michoel
07/18/2022, 11:48 PMd
dcrsmith
07/18/2022, 11:56 PMI ❤️ Tim D
But..... that's not going to work either.
dcrsmith
07/18/2022, 11:57 PMNot sure if this will work faster than a load so I'll have to test but this does work for what I'm looking to do...
Copy code
jQuery.get(location+'&xml=t',function(r){
let xml=new XMLSerializer().serializeToString(r);
console.log(xml);
console.log(/_bluchat_mention/ig.test(xml));
})e
Eric B
07/19/2022, 1:27 AMI use the same methodology of loading the XML representation of the record via the browser and then parsing the XML.
👍 1
12 Views