Share with colleagues and friends who could benefit from our webinars too!
Missing "Time of Day" fields in custom record table suiteQL query?
I have a custom record type with several fields, two of which are of the data type "Time Of Day" -- (start_time and end_time).
When I query the table using the N/query module, all of the fields are available except for the two fields with type "Time of Day" -- I have tried querying by the field ID and I get the error:
Unknown identifier 'custrecord_htl_override_start_time'
Those two fields are also missing when I do a select * on the custom record table.
How can I get these fields data via suiteql?