Can't Figure this one out. Stumped. Any takers?

What were you hoping for? What doesn’t work the way you wanted it too? A bit more context here please?

First table with the count of revisions for the day. Second table is in drawer to the first breaking it down further by page. The third table is in a drawer to the second table displaying the individual revisions for a page and day.

This is useful to get a sense of the actutal time spent on a page.

Very cool page.

I noticed a really nerdy problem that emerges with grouping date fields. In my org (with a lot of worldwide builders) there was a discrepancy between the grouped number of pages from the aggregate query and the detail list of those pages when you query on created date directly.

That’s cuz out of the box - Aggregate queries use the UTC value of a record to group data - while the conditions on normal queries use the User’s TimeZone. So the further east or west you are, the more likely your UTC value and your TimeZone value will fall on different days.

We have included a property on the grouping to correct this. Look for the “Convert to User Timezone” property.

This will keep things in synch. But there is an additional problem.

Generally you want to group by dates but also order by those dates. The wrinkle is that Salesforce appends an extension to the field name when this “Convert to User Timezone property” is selected - and so there is an error if you just try to add CreateDate in the model order property.

So add the extension in your model order property as follows: DAY_ONLY(convertTimezone(CreatedDate)) DESC

And all will be well.

Now I can’t get the PagesRevisions model to query properly. Unable to create a SOQL like this.

select Id, CreatedDate from skuid__Page_Version__c where DAY_ONLY(convertTimezone(CreatedDate)) = 2023-03-20

The convertTimeZone extension only works on Aggregate models. Basic model conditions are already processed using Time Zone.

That’s odd. I tried it in Developer Console without issue.

Seems like a bug. Setting the condition using a Date Value is being converted to a DateTime value, which doesn’t work for a Date field. Clicking into 2nd drawer

<skuid__page unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" showheader="false">
	<models>
		<model id="PagesRevisionsDayAgg" limit="" query="true" createrowifnonefound="false" datasource="salesforce" sobject="skuid__Page_Version__c" type="aggregate" queryallrows="false" orderby="DAY_ONLY(convertTimezone(CreatedDate)) DESC">
			<fields>
				<field id="Id" name="countId" function="COUNT"/>
				<field id="CreatedDate" name="maxCreatedDate" function="MAX"/>
				<field id="CreatedDate" name="minCreatedDate" function="MIN"/>
			</fields>
			<conditions>
				<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" fieldfunction="DAY_ONLY" clientorserver="server" state="filterableoff" inactive="true" name="LTE" operator="lte"/>
				<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" fieldfunction="DAY_ONLY" operator="gte" clientorserver="server" state="filterableoff" inactive="true" name="GTE"/>
			</conditions>
			<actions/>
			<groupby method="simple">
				<field id="CreatedDate" name="doCreatedDate" function="DAY_ONLY" convertToUserTimezone="true"/>
			</groupby>
		</model>
		<model id="PagesRevisionsDayPageAgg" query="false" createrowifnonefound="false" datasource="salesforce" sobject="skuid__Page_Version__c" queryallrows="false" limit="" type="aggregate">
			<fields>
				<field id="Id" name="countId" function="COUNT"/>
			</fields>
			<conditions>
				<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" fieldfunction="DAY_ONLY" clientorserver="server" state="filterableoff" inactive="true" name="CreatedDate"/>
			</conditions>
			<actions/>
			<groupby method="simple">
				<field id="skuid__Page__c" name="skuidPagec"/>
				<field id="skuid__Page__r.Name" name="skuidPagerName"/>
				<field id="CreatedDate" name="doCreatedDate" function="DAY_ONLY" convertToUserTimezone="true"/>
			</groupby>
		</model>
		<model id="PagesRevisions" query="false" createrowifnonefound="false" datasource="salesforce" sobject="skuid__Page_Version__c" queryallrows="false" limit="">
			<fields>
				<field id="CreatedDate"/>
				<field id="skuid__Description__c"/>
				<field id="skuid__Page__c"/>
				<field id="skuid__Page__r.Name"/>
				<field id="CreatedDateDate" uionly="true" displaytype="FORMULA" length="255" label="CreatedDateDate" ogdisplaytype="TEXT" readonly="true" returntype="DATE">
					<formula>{{CreatedDate}}</formula>
				</field>
				<field id="CreatedDateOnly__c"/>
			</fields>
			<conditions>
				<condition type="fieldvalue" value="" enclosevalueinquotes="true" field="skuid__Page__c" fieldtargetobjects="skuid__Page__c" clientorserver="server" state="filterableoff" inactive="true" name="skuid__Page__c"/>
				<condition type="fieldvalue" enclosevalueinquotes="false" field="CreatedDateOnly__c" clientorserver="server" state="filterableoff" inactive="true" name="CreatedDateOnly"/>
			</conditions>
			<actions/>
			<groupby method="simple"/>
		</model>
	</models>
	<components>
		<skuid__wrapper uniqueid="sk-H6T-245359">
			<components>
				<skuid__table allowColumnFreezing="dragDrop" model="PagesRevisionsDayAgg" uniqueid="sk-H4l-52132" mode="readonly" showSaveCancel="false" pageSize="10" enableDrawers="true" 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"/>
					<drawer>
						<beforeLoad>
							<action type="blockUI" styleSettingsVariant="dark"/>
							<action type="updateCondition" model="PagesRevisionsDayPageAgg" behavior="set" condition="CreatedDate" valuesource="formula">
								<formula>{{doCreatedDate}}</formula>
							</action>
							<action type="requeryModels" behavior="loadmore">
								<models>
									<model>PagesRevisionsDayPageAgg</model>
								</models>
							</action>
							<action type="unblockUI"/>
						</beforeLoad>
						<components>
							<skuid__table allowColumnFreezing="dragDrop" model="PagesRevisionsDayPageAgg" uniqueid="sk-H4l-52138" mode="readonly" pageSize="Infinity" showSaveCancel="false" showListFooter="false" showListHeader="false" enableDrawers="true">
								<fields>
									<field type="COMBO" label="Skuid Page" template="{{{skuidPagerName}}}" redirectType="customurl" window="blank" rootUrl="/{{{skuidPagec}}}" uniqueid="fi-fUL-22556"/>
									<field id="Id" name="countId" label="Count" uniqueid="fi-KYI-37935" summaries="sum"/>
								</fields>
								<filtering enableSearch="false"/>
								<actions/>
								<rowActions/>
								<massActions/>
								<exportProperties useTableColumns="true" sanitizeRecords="true" enableExportOptionOnTable="true" loadAllRecords="false"/>
								<sorting enable="false"/>
								<conditions>
									<condition type="contextrow" field="doCreatedDate" mergefield="doCreatedDate" operator="="/>
								</conditions>
								<styles>
									<spacing top="2" right="2" bottom="2" left="2"/>
								</styles>
								<drawer>
									<components>
										<skuid__table allowColumnFreezing="dragDrop" model="PagesRevisions" uniqueid="sk-KdR-27817" mode="read" pageSize="Infinity" showListFooter="false" showListHeader="false" showRowNumbers="true">
											<fields>
												<field id="skuid__Description__c" uniqueid="fi-RIf-32889"/>
												<field id="CreatedDate" uniqueid="fi-RIf-32890"/>
											</fields>
											<filtering enableSearch="false"/>
											<actions/>
											<rowActions/>
											<massActions/>
											<exportProperties useTableColumns="true"/>
											<sorting enable="false"/>
											<conditions>
												<condition type="contextrow" field="skuid__Page__c" mergefield="skuidPagec" operator="=" fieldtargetobjects="skuid__Page__c"/>
												<condition type="contextrow" field="CreatedDateOnly__c" mergefield="doCreatedDate" operator="="/>
											</conditions>
											<styles>
												<spacing top="2" right="2" bottom="2" left="2"/>
											</styles>
										</skuid__table>
									</components>
									<beforeLoad>
										<action type="blockUI" styleSettingsVariant="dark"/>
										<action type="updateCondition" model="PagesRevisions" behavior="set" condition="skuid__Page__c" valuesource="formula">
											<formula>{{skuidPagec}}</formula>
										</action>
										<action type="updateCondition" model="PagesRevisions" behavior="set" condition="CreatedDateOnly" valuesource="formula" sourcemodel="PagesRevisionsDayAgg">
											<formula>{{doCreatedDate}}</formula>
										</action>
										<action type="requeryModels" behavior="loadmore">
											<models>
												<model>PagesRevisions</model>
											</models>
										</action>
										<action type="unblockUI"/>
									</beforeLoad>
								</drawer>
							</skuid__table>
						</components>
					</drawer>
					<renderConditions logictype="and"/>
					<styleVariantConditions/>
					<filters>
						<skuid__filter uniqueId="sk-HEp-21689" type="daterange" conditionSource="manual" labelMode="manual" rememberInPersonalization="false" showTodayButton="false" showMonthYearPicker="false" yearPickerMin="c-10" yearPickerMax="c+10" startConditionName="GTE" endConditionName="LTE"/>
					</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>

Found the direct way to do this properly.

<skuid__page unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" showheader="false">
	<models>
		<model id="PagesRevisionsDayAgg" limit="" query="true" createrowifnonefound="false" datasource="salesforce" sobject="skuid__Page_Version__c" type="aggregate" queryallrows="false" orderby="DAY_ONLY(convertTimezone(CreatedDate)) DESC">
			<fields>
				<field id="Id" name="countId" function="COUNT"/>
				<field id="CreatedDate" name="maxCreatedDate" function="MAX"/>
				<field id="CreatedDate" name="minCreatedDate" function="MIN"/>
			</fields>
			<conditions>
				<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" fieldfunction="DAY_ONLY" clientorserver="server" state="filterableoff" inactive="true" name="LTE" operator="lte"/>
				<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" fieldfunction="DAY_ONLY" operator="gte" clientorserver="server" state="filterableoff" inactive="true" name="GTE"/>
			</conditions>
			<actions/>
			<groupby method="simple">
				<field id="CreatedDate" name="doCreatedDate" function="DAY_ONLY" convertToUserTimezone="true"/>
			</groupby>
		</model>
		<model id="PagesRevisionsDayPageAgg" query="false" createrowifnonefound="false" datasource="salesforce" sobject="skuid__Page_Version__c" queryallrows="false" limit="" type="aggregate">
			<fields>
				<field id="Id" name="countId" function="COUNT"/>
			</fields>
			<conditions>
				<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" fieldfunction="DAY_ONLY" clientorserver="server" state="filterableoff" inactive="true" name="CreatedDate"/>
			</conditions>
			<actions/>
			<groupby method="simple">
				<field id="skuid__Page__c" name="skuidPagec"/>
				<field id="skuid__Page__r.Name" name="skuidPagerName"/>
				<field id="CreatedDate" name="doCreatedDate" function="DAY_ONLY" convertToUserTimezone="true"/>
			</groupby>
		</model>
		<model id="PagesRevisions" query="false" createrowifnonefound="false" datasource="salesforce" sobject="skuid__Page_Version__c" queryallrows="false" limit="">
			<fields>
				<field id="skuid__Description__c"/>
				<field id="skuid__Page__c"/>
				<field id="skuid__Page__r.Name"/>
				<field id="CreatedDateDate" uionly="true" displaytype="FORMULA" length="255" label="CreatedDateDate" ogdisplaytype="TEXT" readonly="true" returntype="DATE">
					<formula>{{CreatedDate}}</formula>
				</field>
				<field id="CreatedDate"/>
			</fields>
			<conditions>
				<condition type="fieldvalue" value="" enclosevalueinquotes="true" field="skuid__Page__c" fieldtargetobjects="skuid__Page__c" clientorserver="server" state="filterableoff" inactive="true" name="skuid__Page__c"/>
				<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" fieldfunction="DAY_ONLY" clientorserver="server" state="filterableoff" inactive="true" name="CreatedDate"/>
			</conditions>
			<actions/>
			<groupby method="simple"/>
		</model>
	</models>
	<components>
		<skuid__wrapper uniqueid="sk-H6T-245359">
			<components>
				<skuid__table allowColumnFreezing="dragDrop" model="PagesRevisionsDayAgg" uniqueid="sk-H4l-52132" mode="readonly" showSaveCancel="false" pageSize="10" enableDrawers="true" 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"/>
					<drawer>
						<beforeLoad>
							<action type="blockUI" styleSettingsVariant="dark"/>
							<action type="updateCondition" model="PagesRevisionsDayPageAgg" behavior="set" condition="CreatedDate" valuesource="formula">
								<formula>{{doCreatedDate}}</formula>
							</action>
							<action type="requeryModels" behavior="loadmore">
								<models>
									<model>PagesRevisionsDayPageAgg</model>
								</models>
							</action>
							<action type="unblockUI"/>
						</beforeLoad>
						<components>
							<skuid__table allowColumnFreezing="dragDrop" model="PagesRevisionsDayPageAgg" uniqueid="sk-H4l-52138" mode="readonly" pageSize="Infinity" showSaveCancel="false" showListFooter="false" showListHeader="false" enableDrawers="true">
								<fields>
									<field type="COMBO" label="Skuid Page" template="{{{skuidPagerName}}}" redirectType="customurl" window="blank" rootUrl="/{{{skuidPagec}}}" uniqueid="fi-fUL-22556"/>
									<field id="Id" name="countId" label="Count" uniqueid="fi-KYI-37935" summaries="sum"/>
								</fields>
								<filtering enableSearch="false"/>
								<actions/>
								<rowActions/>
								<massActions/>
								<exportProperties useTableColumns="true" sanitizeRecords="true" enableExportOptionOnTable="true" loadAllRecords="false"/>
								<sorting enable="false"/>
								<conditions>
									<condition type="contextrow" field="doCreatedDate" mergefield="doCreatedDate" operator="="/>
								</conditions>
								<styles>
									<spacing top="2" right="2" bottom="2" left="2"/>
								</styles>
								<drawer>
									<components>
										<skuid__table allowColumnFreezing="dragDrop" model="PagesRevisions" uniqueid="sk-KdR-27817" mode="read" pageSize="Infinity" showListFooter="false" showListHeader="false" showRowNumbers="true">
											<fields>
												<field id="skuid__Description__c" uniqueid="fi-RIf-32889"/>
												<field id="CreatedDate" uniqueid="fi-RIf-32890"/>
											</fields>
											<filtering enableSearch="false"/>
											<actions/>
											<rowActions/>
											<massActions/>
											<exportProperties useTableColumns="true"/>
											<sorting enable="false"/>
											<conditions>
												<condition type="contextrow" field="skuid__Page__c" mergefield="skuidPagec" operator="=" fieldtargetobjects="skuid__Page__c"/>
												<condition type="contextrow" field="CreatedDateDate" mergefield="doCreatedDate" operator="="/>
											</conditions>
											<styles>
												<spacing top="2" right="2" bottom="2" left="2"/>
											</styles>
										</skuid__table>
									</components>
									<beforeLoad>
										<action type="blockUI" styleSettingsVariant="dark"/>
										<action type="updateCondition" model="PagesRevisions" behavior="set" condition="skuid__Page__c" valuesource="formula">
											<formula>{{skuidPagec}}</formula>
										</action>
										<action type="updateCondition" model="PagesRevisions" behavior="set" condition="CreatedDate" valuesource="formula" sourcemodel="PagesRevisionsDayAgg">
											<formula>{{doCreatedDate}}</formula>
										</action>
										<action type="requeryModels" behavior="loadmore">
											<models>
												<model>PagesRevisions</model>
											</models>
										</action>
										<action type="unblockUI"/>
									</beforeLoad>
								</drawer>
							</skuid__table>
						</components>
					</drawer>
					<renderConditions logictype="and"/>
					<styleVariantConditions/>
					<filters>
						<skuid__filter uniqueId="sk-HEp-21689" type="daterange" conditionSource="manual" labelMode="manual" rememberInPersonalization="false" showTodayButton="false" showMonthYearPicker="false" yearPickerMin="c-10" yearPickerMax="c+10" startConditionName="GTE" endConditionName="LTE"/>
					</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>

@Rob_Hatch Now add the functionality from this idea.

Similar to what Salesforce Audit Trail does, it would be great if Skuid pages had a similar reporting capability. I’ve found this js that seems like it would great. diff-js-xml I can see this being pretty slick for Skuid page builders needing to easily capture the changes for reporting purposes. As any decent builder knows, it’s way faster to build a page from an idea than to write down any technical requirements beforehand. A user story and acceptance criteria is all that is needed, along wit…