How can I use this field in suiteql, i am getting this error Search error occurred: Field 'custevent_nx_start_time' for record 'Task' was not found. Reason: UNSUITABLE - Unsupported data type 'TIMEOFDAY'

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that the 'TimeOfDay' field type has limited support in SuiteQL. This is likely the reason you're encountering the error when trying to use the 'custevent_nx_start_time' field in your SuiteQL query. A workaround suggested in the threads is to load the record using the record module in SuiteScript, which should allow you to access the 'TimeOfDay' field. Another suggestion is to use the

setValue

method with a Date object or the

setText

method with a formatted string. However, please note that these are workarounds and may not be suitable for all use cases. Unfortunately, it seems that there is no definitive solution to this issue at the moment, as the support for certain field types in SuiteQL is limited. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******