Hey yall - I’m trying to query a custom record and...
# suiteqlc
Cory Weiner
10/25/2021, 2:38 PMHey yall - I’m trying to query a custom record and all of the fields are available except for two fields which are of type “Time Of Day” — has anyone else had issues accising this field type via suiteql / N/query module?
c
Clay Roper
10/25/2021, 3:35 PMWhen you say they're unavailable, what do you mean?
c
Cory Weiner
10/25/2021, 3:36 PMI get the error “Unknown identifier ‘custrecord_htl_override_start_time’”
Cory Weiner
10/25/2021, 3:36 PMAnd when I do a select * on the table, those two columns are missing
a
Anthony (NimbusLabs)
10/25/2021, 3:55 PMAre they unstored values?
c
Cory Weiner
10/25/2021, 3:56 PMNo they are checked “store value”
Cory Weiner
10/25/2021, 3:56 PM Copy code
<customrecordcustomfield scriptid="custrecord_htl_override_start_time">
<accesslevel>2</accesslevel>
<description></description>
<displaytype>NORMAL</displaytype>
<fieldtype>TIMEOFDAY</fieldtype>
<label>Start Time</label>
<showinlist>T</showinlist>
<searchlevel>2</searchlevel>
<storevalue>T</storevalue>
</customrecordcustomfield>Cory Weiner
10/25/2021, 3:56 PMField definition
c
Clay Roper
10/25/2021, 9:36 PM@Cory Weiner Any luck?
Clay Roper
10/25/2021, 9:37 PMI remember having some significant issues with time of day and query, but it was long enough ago that I've successfully blocked it from memory. I believe that, for that project, we ended up refactoring to use N/search
Clay Roper
10/25/2021, 9:38 PMFound my contact with support - there's a defect filed for it, 608891
8 Views