Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 02:07
    MarcRohde opened #861
  • Feb 06 20:26
    rappen closed #274
  • Feb 06 20:26
    rappen commented #274
  • Feb 06 20:25
    rappen commented #266
  • Feb 06 20:23
    rappen labeled #146
  • Feb 06 20:22
    rappen closed #144
  • Feb 06 20:22
    rappen commented #144
  • Feb 06 20:19
    rappen commented #801
  • Feb 06 20:17
    rappen closed #125
  • Feb 06 20:17
    rappen commented #125
  • Feb 06 20:17
    rappen closed #118
  • Feb 06 20:17
    rappen commented #118
  • Feb 06 20:12
    rappen closed #111
  • Feb 06 20:12

    rappen on master

    Finally after 7 years - implemeā€¦ (compare)

  • Feb 06 19:26
    rappen closed #106
  • Feb 06 19:26
    rappen commented #106
  • Feb 06 19:25
    rappen closed #105
  • Feb 06 19:25
    rappen commented #105
  • Feb 06 19:21
    rappen closed #89
  • Feb 06 19:20
    rappen closed #9
MscrmTools
@MscrmTools
Did you download XrmToolBox first?
Ravi Vijayakumar
@ravindranee_twitter
yes
MscrmTools
@MscrmTools
so you just have to open the plugins store (button in the menu bar) and select FecthXmlBuilder
then click on Install buton
Ravi Vijayakumar
@ravindranee_twitter
ok
Yohan Delmas
@yodelmas_twitter
Hy guys, I have a question, I am using Export to excel plugin with fetchxmlbuilder. I want to export record in XLSX. It works well but I can't export the regardingobjectid in guid (export to excel convert the column with metadata in Excel...). How can I do that ?
Jonas Rapp
@rappen
Hi - I suggest you submit an issue to the Export To Excel repo on GitHub: https://github.com/rajyraman/mscrmexporttoexcel
Then you can get a response from the author of the tool :+1:
Yohan Delmas
@yodelmas_twitter
I did it. Thank yo
Sharepoint PFE
@SharepointPFE_twitter
hello
I'm having an issue trying to install FetchXML builder into our XRMToolbox. I don't have a button to go find it in the store
MscrmTools
@MscrmTools
Not sure to understand... you can't see it in the Plugins Store?
Alexey Shytikov
@shytikov
Update to most recent version of XTB?
Kiquenet
@kiquenet
Hi, FetchXML Builder not Works for CRM 2011 ? I get an error, but allOK using CRM 2016.
Jonas Rapp
@rappen
Yes it should work. What error? Or submit issue on github.
mkcgphy
@mkcgphy
I want to get the count of parent entity which has linked entity
I am doing aggregation here
For eg. Contact has case associated with it
I want to count all the contacts from so and so date having cases with certain case title
there can be multiple cases for each contact
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" aggregate="true">
<entity name="abc_entity">
<attribute name="abc_name" alias="EntityName" aggregate="countcolumn"/>
<attribute name="createdon" alias="createdonyear" groupby="true" dategrouping="year"/>
<attribute name="createdon" alias="createdonmonth" groupby="true" dategrouping="month"/>
<attribute name="createdon" alias="createdonweek" groupby="true" dategrouping="day"/>
<filter type="and">
<condition attribute="abc_applicationdate" operator="on-or-after" value="@Start_date"/>
<condition attribute="abc_applicationdate" operator="on-or-before" value="@EndDate"/>
<condition attribute="abc_productid" operator="in">
</condition>
</filter>
<link-entity name="abc_entitydocument" from="abc_entityid" to="abc_entityid" alias="av" link-type="inner">
<attribute name="createdon" alias="CreatedDate" aggregate="max"/>
<filter type="and">
<condition attribute="abc_document" operator="not-null"/>
<condition attribute="abc_entityid" operator="not-null"/>
</filter>
</link-entity>
</entity>
</fetch>
I am not sure how will it work
Jonas Rapp
@rappen
Hi mkcgphy!
So what about the fetch you sent - does it work?
It does not count contacts and cases, that is for sure...
mkcgphy
@mkcgphy
No it doesnt work at all
normal query without aggregation works
but it is giving me different count
if someone can help me getting accurate data that highly appreciated
rynh
@rhino_scrapp_twitter
Hello everyone! how I can enable the option to aggregate and groupby
Total Thanks
Jonas Rapp
@rappen
Select the fetch node at the top, and then check the Aggregate box.
Jonas Rapp
@rappen
@rajyraman Do you have any idea what might be causing this behavior reported by @medevil84 ? Innofactor/XrmToolBox.BulkDataUpdater#7
Marcosfau
@Marcosfau
Hi Masters
I have questions with the fetchxml
From the plugin store, I have installed it to XrmlToolBox, set options all for Entities and Attributes. Collect to CRM 365. Selected account entity in open views, but when I press refresh view, nothing show up.
Jonas Rapp
@rappen
blob
Hi - do you mean like this?
Marcosfau
@Marcosfau
Oh it is fixed..after restart computer Thanks
Jonas Rapp
@rappen
A reboot fixes anything.... almost ;)
Marcosfau
@Marcosfau
;)
Daryl LaBar
@daryllabar
Do distincts not work on linked attributes?
<fetch distinct="true" >
<entity name="allgnt_job" >
<filter>
<condition attribute="createdon" operator="last-x-months" value="12" />
</filter>
<link-entity name="dfnd_timeslot" from="dfnd_timeslotid" to="dfnd_timeslotid" link-type="inner" >
<attribute name="dfnd_tblreftimeslot_timeslotid" alias="TimeSlotCount" />
</link-entity>
</entity>
</fetch>
MscrmTools
@MscrmTools
nop
had the same problem some times ago
(AFAIK)
Daryl LaBar
@daryllabar
Flipping my query so the TimeSlot was the primary worked...
so, I'll agree with you @MscrmTools
Now stop talking to me and correcting my blogs, and pointing out that TipOfTheDay already has my lack of knowledge covered, and go an enjoy your Friday!
MscrmTools
@MscrmTools
still working by now :) but I will go to the haircut in few minutes to look good in Lisbon :D
Syed Sajid Hussain
@SyedSajid08_twitter
Hello everyone