Agg Model with Grouped Date field w/ UTC can't be grouped with same field V2 16.0.3

[Jeanguy_Vachon]

Un-checking this option resolves the issue.

<skuid__page unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" showheader="false">
	<models>
		<model id="GroupedDateTimeDayOnlyUTC" limit="" query="true" createrowifnonefound="false" datasource="salesforce" sobject="skuid__Page_Version__c" type="aggregate" queryallrows="false" orderby="DAY_ONLY(CreatedDate) DESC">
			<fields>
				<field id="Id" name="countId" function="COUNT"/>
			</fields>
			<conditions/>
			<actions/>
			<groupby method="simple">
				<field id="CreatedDate" name="doCreatedDate" function="DAY_ONLY" convertToUserTimezone="true"/>
			</groupby>
		</model>
	</models>
	<components>
		<skuid__wrapper uniqueid="sk-H6T-245359">
			<components>
				<skuid__table allowColumnFreezing="dragDrop" model="GroupedDateTimeDayOnlyUTC" uniqueid="sk-H4l-52132" mode="readonly" showSaveCancel="false" pageSize="10" enableDrawers="false" title="Revisions">
					<fields>
						<field id="CreatedDate" name="doCreatedDate" label="Created Date" uniqueid="fi-H5b-73131"/>
						<field id="Id" name="countId" label="Revisions" uniqueid="sk-H4l-52133"/>
					</fields>
					<filtering enableSearch="false"/>
					<actions displayType="attached"/>
					<rowActions/>
					<massActions/>
					<exportProperties useTableColumns="true" sanitizeRecords="true"/>
					<sorting enable="false"/>
					<renderConditions logictype="and"/>
					<styleVariantConditions/>
					<filters/>
					<styles>
						<spacing/>
					</styles>
				</skuid__table>
			</components>
			<styles>
				<spacing top="2" right="2" bottom="2" left="2"/>
			</styles>
			<background/>
		</skuid__wrapper>
	</components>
	<resources>
		<labels/>
		<javascript/>
		<css/>
		<actionsequences/>
	</resources>
	<styles>
		<styleitem type="background" bgtype="none"/>
	</styles>
</skuid__page>

[Anna_Wiersema]

Hey Pat, try DAY_ONLY(convertTimezone(CreatedDate))

Troubleshooting: Order By for Aggregate Models

PROBLEM: When you order the records in an aggregate model by a date field with Convert to User Timezone enabled, the model doesn’t load and you get the error “Ordered field must be grouped.” [|529x105.29740923074893] RESOLUTION: Add the convertTimezone function to Fields to order records by in the model’s properties, e.g. instead of using DAY_ONLY(CreatedDate), the grouping field without the timezone conversion, use DAY_ONLY(convertTimezone(FieldName)). [|623.9999999999999x157] Problem Deta…

Sometimes to get the correct name for grouping fields for an aggregate model, it helps to run skuid.debug.modelMap() in the console and find out what the field is called in the SQL

TemplateFields.xml (1.2 KB)