You’re offline. This is a read only version of the page.
Hello,
I am a beginner when it comes to portals and programming.
I am trying to create a filter in a portal based on date and time. So, sessions scheduled after 'now' should not be displayed. The FetchXML below only works on date but does not seem to consider the time.
I have tried different formats, but it does not include the end time in the filtering.
Does anyone have an idea on how to solve this?"
<fetch>
<entity name="msevtmgt_session" >
<attribute name="msevtmgt_name" alias="name" />
<attribute name="msevtmgt_starttime" alias="start" />
<attribute name="msevtmgt_endtime" />
<attribute name="han_sessie_zonder_begin_eindtijd" alias="withoutdate" />
<attribute name="han_sessiesoort" alias="sessiesoort" />
<filter type="and" >
<condition attribute="msevtmgt_event" operator="eq" value="203b905c-59b4-ee11-a569-000d3adf6c55" uitype="msevtmgt_event" />
<condition attribute="msevtmgt_publishstatus" operator="eq" value="100000003" />
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="msevtmgt_endtime" operator="on-or-after" value="2024-01-19T11:00:00" />
</filter>
</entity>
</fetch>
Output
What timezone are you in? It seems to correct for a timezone UTC+1?
#1
Fubar
69
Super User 2025 Season 1
#2
oliver.rodrigues
49
Most Valuable Professional
#3
Jon Unzueta
43
Share
Report
All responses (
Answers (
