https://community.esri.com/t5/arcgis-enterprise-questions/create-view-layer-expression-filter-functionality/m-p/1266496#M35370 <P>Hi there,&nbsp;</P><P>I am working in an Enterprise Portal (version 11x) and would like to know if there are limited filter expressions compared to ArcGIS Online when working with date/time fields. I am trying to select records that have been recorded in the last 24 hours and create a hosted layer view.&nbsp;</P><P>In ArcGIS Online, you are able to use fixed-date and relative-date filter expressions:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="OliverPannell_0-1678466090217.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/64915i43DE91ABE9AB8129/image-size/medium?v=v2&amp;px=400" role="button" title="OliverPannell_0-1678466090217.png" alt="OliverPannell_0-1678466090217.png" /></span></P><P>However, when working in Portal v11, these options are not available in the view layer options (they are available in the dashboard options though - <A href="https://doc.arcgis.com/en/dashboards/11.0/get-started/date-based-filter-conditions.htm" target="_blank" rel="noopener">Date-based filter conditions—ArcGIS Dashboards | Documentation) :&nbsp;</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="OliverPannell_2-1678466166321.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/64919i8C2DCA0DF1AE3029/image-size/medium?v=v2&amp;px=400" role="button" title="OliverPannell_2-1678466166321.png" alt="OliverPannell_2-1678466166321.png" /></span></P><P>1. Can anybody confirm if there are functionality differences between the two filter expression options in the create layer view options in Portal v11 and ArcGIS Online?&nbsp;</P><P>2. Does anybody know of a work around to create a hosted layer view only showing records from the last 24 hours if the filter expressions are limited to fixed-date only in Portal?</P><P>Many thanks,&nbsp;</P><P>Ollie</P><P>&nbsp;</P> Fri, 10 Mar 2023 17:05:05 GMT OliverPannell 2023-03-10T17:05:05Z https://community.esri.com/t5/arcgis-enterprise-questions/create-view-layer-expression-filter-functionality/m-p/1266496#M35370 <P>Hi there,&nbsp;</P><P>I am working in an Enterprise Portal (version 11x) and would like to know if there are limited filter expressions compared to ArcGIS Online when working with date/time fields. I am trying to select records that have been recorded in the last 24 hours and create a hosted layer view.&nbsp;</P><P>In ArcGIS Online, you are able to use fixed-date and relative-date filter expressions:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="OliverPannell_0-1678466090217.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/64915i43DE91ABE9AB8129/image-size/medium?v=v2&amp;px=400" role="button" title="OliverPannell_0-1678466090217.png" alt="OliverPannell_0-1678466090217.png" /></span></P><P>However, when working in Portal v11, these options are not available in the view layer options (they are available in the dashboard options though - <A href="https://doc.arcgis.com/en/dashboards/11.0/get-started/date-based-filter-conditions.htm" target="_blank" rel="noopener">Date-based filter conditions—ArcGIS Dashboards | Documentation) :&nbsp;</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="OliverPannell_2-1678466166321.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/64919i8C2DCA0DF1AE3029/image-size/medium?v=v2&amp;px=400" role="button" title="OliverPannell_2-1678466166321.png" alt="OliverPannell_2-1678466166321.png" /></span></P><P>1. Can anybody confirm if there are functionality differences between the two filter expression options in the create layer view options in Portal v11 and ArcGIS Online?&nbsp;</P><P>2. Does anybody know of a work around to create a hosted layer view only showing records from the last 24 hours if the filter expressions are limited to fixed-date only in Portal?</P><P>Many thanks,&nbsp;</P><P>Ollie</P><P>&nbsp;</P> Fri, 10 Mar 2023 17:05:05 GMT https://community.esri.com/t5/arcgis-enterprise-questions/create-view-layer-expression-filter-functionality/m-p/1266496#M35370 OliverPannell 2023-03-10T17:05:05Z