How to find the difference between custom and normal attributes in table schema.

[adigelli]

Hi Team,

I am able to get the schema of a particular table. the table contains custom attributes as well.

Can i know how to differentiate from existing and custom attributes from the schema. ( like any attribute like that).

Thanks in Advance.

[Ivano B]

Ok On which table are you working at the moment ?

[chris_smith]

Hi -

Hopefully this helps, but on your custom table from the schema map view there is typically a few expandable lists on the table its self.

The 'Columns' one is typically the custom fields for your table and the 'Task Columns' (depending on if you extended it from Task) would show those that the custom table inherited.

You can also click directly on any of the listings and go directly to the field in case you need the variable name as well.

[adigelli]

Hi R0bo/Smith

"I am programmatically     trying to extract custom columns/attributes from the user table and need a robust way to do it. Something that will not break when ServiceNow implementation changes the prefix character"

"Is there any other attribute/bit that is set for a custom column/schema that declares that it is custom created?"

Thanks

[chris_smith]

Hi staging dev,

To my knowledge, the only identifier on the user table (or any out of box table) for custom fields would be the "u_" prefix. Regarding a custom application, in my experience, the variables do not have a prefix because the application is separate from all the other ServiceNow applications. Your only option may be to focus on the dictionary 'Column Name' for those that start with the "u_" prefix. I can't imagine they would change the prefix any time soon since it's been like that for years, but I'm not a mind reader.

[Ivano B]

Totally agreed with Christopher

I don't think this behaviour will change...never did in the last 7 years