777
So I am wanting only "scheduled" appointments to be showing up in my view, and as far as I can tell, I have set the filter criteria to make this happen. However, "completed" appointments are still popping up in the view!
I have attached a picture of my filter criteria - can anyone find the bug that's preventing me from getting this view to only show scheduled appointments?
*This post is locked for comments
Hi Ben,
I am not sure if this is something related to what you have inside you OR Statement, but I created a similar logic, and it would only display the Scheduled Appointments:
<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="appointment">
<attribute name="subject"/>
<attribute name="statecode"/>
<attribute name="scheduledstart"/>
<attribute name="scheduledend"/>
<attribute name="createdby"/>
<attribute name="regardingobjectid"/>
<attribute name="activityid"/>
<attribute name="instancetypecode"/>
<order descending="false" attribute="subject"/>
<filter type="and">
<condition attribute="statecode" value="3" operator="eq"/>
<filter type="or">
<condition attribute="scheduledstart" operator="today"/>
<condition attribute="scheduledend" operator="today"/>
</filter>
<condition attribute="createdby" operator="eq-userid"/>
</filter>
</entity>
</fetch>
Please check your query again.
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (