Innofactor/FetchXMLBuilder

FetxhXML Builder for XrmToolBox http://fxb.xrmtoolbox.com

Jonas Rapp

@rappen

Yep

Daryl LaBar

@daryllabar

So I could encode my settings into some weird string, and then be able to parse that after the fact.

interesting

Jonas Rapp

@rappen

You want to keep track of which settings are most used?

Daryl LaBar

@daryllabar

I'm wondering. Then I can just disable settings that no-one uses...

Jonas Rapp

@rappen

un-bloating a bit never hurt anybody

Daryl LaBar

@daryllabar

Or Course: https://media3.giphy.com/media/kQ2zIWHb9yEes/200.webp#2

Jonas Rapp

@rappen

:+1:

Naveen Koya

@topsidestone_twitter

Hi, I have modified a few system views to add the below statement. But recently noticed that these views are not selectable on a dashboard.

<link-entity name="appointment" from="regardingobjectid" to="accountid" link-type="outer" alias="ac" >
  <filter type="and" >
    <condition attribute="scheduledstart" operator="last-x-weeks" value="4" />
    <condition attribute="statecode" operator="eq" value="1" />
  </filter>
</link-entity>

there is a workaround for this, first I remove the lines modified in Fxmlbuilder, add the view to dashboard and then put the lines back into the system view

Do you know if MS has changed or disabled settings which may be preventing views modified and saved from Fetchxml builder not be able to select on dashboard

Jonas Rapp

@rappen

Hi! Thanks for sharing! I would guess CRM excludes the view as it is not able to parse the query, just like you cannot select "too advanced" views in Adv Find. And your work around should be the way to do it then.

Naveen Koya

@topsidestone_twitter

Thanks Jonas. Makes sense. the workaround works fine.

Jonas Rapp

@rappen

:+1:

DarioTrivoli

@DarioTrivoli

Hello

Jonas Rapp

@rappen

MuraliMohanR

@MuraliMohanR

I am new to xrm toolbox

MscrmTools

@MscrmTools

MuraliMohanR

@MuraliMohanR

I need fetch xml with condition and condition and (condition or condition)

how I can achieve this

MscrmTools

@MscrmTools

You can add child Filters under Filter

so you should have one parent Filter

then two child filter (one with and, the other one with OR)

then add conditions in each filters

MuraliMohanR

@MuraliMohanR

this is I have so far

MscrmTools

@MscrmTools

MuraliMohanR

@MuraliMohanR

MscrmTools

@MscrmTools

there is no meaning to have an "OR" filter with only one condition

MuraliMohanR

@MuraliMohanR

here the above three are compulsory and there should be and with either Ftype eq ="something" or Ftype="somthing2"

MscrmTools

@MscrmTools

here is more what you are after I guess

oh ok I see

so your filter is ok but just add as many Ftype condition as needed

OR you can also use only AND with all conditions and have a condition with IN operator where you can provide multiple valid values

MuraliMohanR

@MuraliMohanR

I hope this is fine

MscrmTools

@MscrmTools

yes it is or you can make it simple with

<filter type="and" >
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="gdit_contractorid" operator="eq" value="82F2B18C-C42A-E711-8104-5065F38B26A1" />
<condition attribute="gdit_assessmentid" operator="not-null" />
<condition attribute="FType" operator="in" >
<value>something1</value>
<value>something2</value>
</condition >
</filter>

I'm entering a meeting, have a good day

MuraliMohanR

@MuraliMohanR

cheers, thank you

Faiyaz

@faiyazshaik_twitter

Hello, I am using FethXml Builder and I am able to do a query which I want

but the "Save View" option is disbaled.

How do I save the view into CRM ?

MscrmTools

@MscrmTools

AFAIK, you can save view only if you opened the query from a view

Faiyaz

@faiyazshaik_twitter

Thanks, will try that

Where communities thrive

People

Repo info

Activity