Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 13:38
    rappen closed #744
  • 13:38

    rappen on master

    Max width for result columns #7… (compare)

  • 12:58

    rappen on master

    A few small fixes Updated submodule - showing pro… (compare)

  • 06:04
    rappen opened #744
  • Jun 30 19:08

    rappen on view-layout

    Minor fix (compare)

  • Jun 30 19:05

    dependabot[bot] on nuget

    (compare)

  • Jun 30 19:05
    dependabot[bot] commented #742
  • Jun 30 19:05
    rappen closed #742
  • Jun 30 19:05
    rappen closed #742
  • Jun 30 19:03

    rappen on view-layout

    Extremely big change and rearra… Big merge from master plus a fe… (compare)

  • Jun 30 18:28

    rappen on master

    Fixing using's by Codeaid (compare)

  • Jun 30 15:32

    rappen on master

    Restructuring all files Restructering extensions Restructuring namespaces and 2 more (compare)

  • Jun 30 15:32
    rappen closed #743
  • Jun 30 15:32
    rappen opened #743
  • Jun 30 15:30

    rappen on restructuring

    Restructuring all files Restructering extensions Restructuring namespaces and 1 more (compare)

  • Jun 27 04:03
    dependabot[bot] labeled #742
  • Jun 27 04:03
    dependabot[bot] opened #742
  • Jun 27 04:03

    dependabot[bot] on nuget

    Bump NuGet.Frameworks from 5.9.… (compare)

  • Jun 26 10:00
    rappen closed #727
  • Jun 26 10:00
    rappen commented #727
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
Hi
MuraliMohanR
@MuraliMohanR
Hi
I am new to xrm toolbox
MscrmTools
@MscrmTools
hi
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
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" >
<entity name="documents" >
<attribute name="documentsid" />
<attribute name="name" />
<attribute name="section" />
<attribute name="filetype" />
<attribute name="documentlink" />
<attribute name="createdon" />
<attribute name="assessmentid" />
<attribute name="contractorid" />
<attribute name="uploadeddate" />
<filter type="and" >
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="contractorid" operator="eq" value="82F2B18C-C42A-E711-8104-5065F38B26A1" />
<condition attribute="assessmentid" operator="not-null" />
</filter>
</entity>
</fetch>
MscrmTools
@MscrmTools
<filter type="and" >
<filter type="and" >
<condition attribute="statecode" operator="eq" value="0" />
</filter>
<filter type="or" >
<condition attribute="contractorid" operator="eq" value="82F2B18C-C42A-E711-8104-5065F38B26A1" />
<condition attribute="assessmentid" operator="not-null" />
</filter>
</filter>
MuraliMohanR
@MuraliMohanR
<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" />
<filter type="or">
<condition attribute="FType" operator="eq" value="something" />
</filter>
</filter>
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
<filter type="or" >
<filter type="and" >
<condition attribute="statecode" operator="eq" value="0" />
</filter>
<filter type="and" >
<condition attribute="contractorid" operator="eq" value="82F2B18C-C42A-E711-8104-5065F38B26A1" />
<condition attribute="assessmentid" operator="not-null" />
</filter>
</filter>
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
<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" />
<filter type="or">
<condition attribute="FType" operator="eq" value="something" />
<condition attribute="FType" operator="eq" value="something1" />
</filter>
</filter>
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" >
</condition >
</filter>
<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
Rsilla
@Rsilla
@rappen hi. Hope your well, trying to create a view with fetchxml. i want to view all resolved cases where an email received has attached to the case after it has been resolved. typical customer behavior of replying to non-reply emails from crm, so the customer complains that nothing is being done but since we don't have visibility as the email attaches to the resolved case. tried to create this with advanced find and fetchxml without success. Any ideas
Jonas Rapp
@rappen
Hi!
I understand your problem... The hard part here is that you want to compare email.createdon with case.resolutiondate. And FetchXML does not support conditions comparing two field values.
I don't see how you can solve this with a query. I think you have to create a workflow that triggers on create email, and then check if regarding case has been resolved. If so, you could either re-open the case, create a task for this email, or something like that.
Makes sense?
Rsilla
@Rsilla
yup. thank you. will give it a try or maybe a plugin could help!
Jonas Rapp
@rappen
A plugin always helps - Jonas' First Rule ;)
CrmHM
@CrmHM
Hi
How to export results (Raw Fetch results in my case) with another encoding?
I have some data in Hebrew
Any ideas?
Jonas Rapp
@rappen
Aouch.... that might not be so easy. Is it possible to open saved file with some other editor and re-save with desired encoding? Or is information lost on the way then?
CrmHM
@CrmHM
Yes, it works (Another editor or FetchXML Tester). But I was wondering if there was a faster way.
Thank you
Jonas Rapp
@rappen
Sorry, no. But add an issue and it might get implemented!