How to find a column on a table that is mandatory

[dennisandrison]

On my catalog items, someone has made a field called phone number mandatory on one of the variables or in a table and when selecting SAVE on the catalog form, I get a message that states Phone number is mandatory.  I have checked all the UI policies and they are not my issue, so I am thinking somewhere in the system there is a field on a table or form somewhere that someone made mandatory that is throwing the error when saving.  Any ideas on how to debug or is there a logging module that will log all client or server side errors

[scott barnard1]

Check the Dictionary

[scott barnard1]

Is it on a catalog item or is it on the form record itself? 

[dennisandrison]

when a do f12 and inspect i get this message

Unloaded table does not match current table sc_cat_item
js_includes_concourse.jsx?v=09-12-2018_0933&lp=Thu_Oct_18_07_49_02_PDT_2018&c=16_236:25304 flash() called for 'sc_req_item.ni.VE26d1b27ddb5627003612f77c299619ef' but there is no label for it
js_includes_concourse.jsx?v=09-12-2018_0933&lp=Thu_Oct_18_07_49_02_PDT_2018&c=16_236:12135 snPresence response time 836ms

[scott barnard1]

Hi dennis

I wouldn't normally start to debug mandatory in the browser dev tools. There are probably some good stuff in there but there are a few basic checks you want to try first

Go to one of the items

maintain items - pick one of them

Check it for a variable set that contains phone number, see if that is mandatory or has a policy or client script that uses setMandatory or has a policy action of mandatory.

I would hazard a guess that it's in a variable set rather than an individual action on each item.

Then check the sc_req_item table and see if it has a field for phone number and see if it's mandatory.

Regards