Check out the latest Field Service updates!Learn about the key capabilities and features of Dynamics 365 Field Service and experience some of the new features.
Download overview guide | Watch Field Service video
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Hi, I have customized the Schedule Board and added some fields and filters. I didn't have issues with combo-boxes or date filters, but interestingly enough, I'm having issues with a LIKE filter.
I have added a new text field to my filters area, here's a simple screenshot including only this field I called "Search Box":
The idea is that the user enters any text in this text-box and my UFX query applies a LIKE to 2 or more fields. In this case, I'm having trouble with even one field. I added this field to the Scheduler:
<attribute name="fig_routenumber" alias="fig_routenumber" groupby="true"/>
This field is a custom field added to the Bookable Resource entity. So I would like to perform a LIKE operation to this new field:
<filter type="and"> <condition attribute="fig_routedate" operator="eq" ufx:if="$input/routedate"> <ufx:value select="$input/routedate" attribute="value" /> </condition> <condition attribute="fig_routenumber" operator="like" ufx:if="$input/searchbox"> <ufx:value select="$input/searchbox" attribute="value" /> </condition></filter>
This filter does not seem to work. It seems to work as an EQUAL instead of a LIKE, and once I clear the SearchBox field, it just doesn't return anything, instead of clearing out the filter it keeps executing an EQUAL to an empty string and I get an empty board:
So basically my question is: How do I add a LIKE operator filter properly?
have you tried adding the wildcards to your search? %word%
Actually no, but where would I add those? Does the UFX syntax allow wildcards?
If I was writing a FetchXML statement it would be with those wildcards. but in this case I don't know where to add them. According to this site:
Without the wildcards, the UFX query should be translated into the correct FetchXML with wildcards:
The above code doesn't really work for me.
Is there a way to see the exact FetchXML statement being executed from the Schedule Board?
I re-read your answer and you are absolutely right, by adding the wildcards to the search box it works (to some extent):
Still seems a bit weird that I need to tell the users to use wildcards for their searches. But I guess I can live with that. Any idea how I can fix this when the search box is empty:
I have to tell them to put "%" on their search every time? It seems a bit weird to me that this is the only way around this.
Its because you can specify a few terms like so:
Resources that end in 123 - %123
Resources that starts with 123 - 123%
Resources that contain 123 - %123%
I have a requirement to add text field within the Filter layout on Schedule Board. I wanted the syntax for adding text field control within “Filter Layout” query on schedule Board.
Can you assist me with the Filter Layout Query?
Business Applications communities