Where communities thrive

Join over 1.5M+ people
Join over 100K+ communities
Free without limits
Create your own community

Explore more communities

Innofactor/FetchXMLBuilder

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

People

Repo info

Activity

Jan 08 04:04

dependabot[bot] on nuget

(compare)
Jan 08 04:04

dependabot[bot] closed #441
Jan 08 04:04

dependabot[bot] commented #441
Jan 08 04:04

dependabot[bot] labeled #449
Jan 08 04:04

dependabot[bot] opened #449
Jan 08 04:04

dependabot[bot] on nuget

Bump MscrmTools.Xrm.Connection … (compare)
Jan 07 04:15

dependabot[bot] labeled #448
Jan 07 04:15

dependabot[bot] opened #448
Jan 07 04:15

dependabot[bot] labeled #447
Jan 07 04:15

dependabot[bot] opened #447
Jan 07 04:15

dependabot[bot] on nuget

Bump Microsoft.CrmSdk.XrmToolin… (compare)
Jan 07 04:15

dependabot[bot] on nuget

Bump Microsoft.CrmSdk.XrmToolin… (compare)
Jan 07 04:15

dependabot[bot] labeled #446
Jan 07 04:15

dependabot[bot] opened #446
Jan 07 04:15

dependabot[bot] on nuget

Bump Microsoft.CrmSdk.XrmToolin… (compare)
Jan 05 13:51

rappen opened #445
Jan 04 04:20

dependabot[bot] on nuget

(compare)
Jan 04 04:20

dependabot[bot] closed #443
Jan 04 04:20

dependabot[bot] commented #443
Jan 04 04:20

dependabot[bot] labeled #444

Daryl LaBar

@daryllabar

no problem dumbbum ;) #BeenThereDoneThat

'#Spelled"There"CorrectlyForJonas'sSake...

Jonas Rapp

@rappen

Shannon Holck

@SMHolck

New to Dynamics, but want to test out FetchXMLBuilder ... XrmToolBox says incompatible with this version (1.2017.7.18) ... any ideas what I need to do? First time using XrmToolBox too. Sorry, such a nube!

MscrmTools

@MscrmTools

Download latest version of XrmToolBox first at https://www.xrmtoolbox.com

Shannon Holck

@SMHolck

Thanks, @MscrmTools ! I think it is working now. yay!

MscrmTools

@MscrmTools

You’re welcome! And... welcome to the magnificent world of XrmToolBox 😁 I hope (well, I’m sure!) it will help you a lot in your work with D365

Shannon Holck

@SMHolck

Is it possible to open more than one FetchXML file at a time?

Daryl LaBar

@daryllabar

@SMHolck you can have multiple instances of the plugin open.

Yatin Babaria

@ya_tin_twitter

What should be the value in "Paging Cookie" to enable paging when number of records are more than 5K

Jonas Rapp

@rappen

You can see the paging cookie when you use the Raw fetch result option. Then you can copy this from the results to your query for next page.

You can also use this option to always get all pages.

Yatin Babaria

@ya_tin_twitter

Thanks Jonas.. :)

Jonas Rapp

@rappen

TheFlyingBadger

@MelesVolans_twitter

Hey guys

Can anyone help with a quick FetchXML question...

Nice'n'easy, yeah? A couple of attributes from the first systemuser record...

Is there any way I can suppress the @name, @dsc, @type attributes of businessunitid from being sent by the FetchXML? In my "real" use cases, i'm using FetchXML to populate a datamart and the sending across of this type of lookup data for all my rows is wasting bandwidth!

Daryl LaBar

@daryllabar

Why not use the WebAPI?

If you truly don't want it, you could apply an XLST

TheFlyingBadger

@MelesVolans_twitter

@daryllabar - a) I'm using SSIS with the Kingswaysoft extension, so FetchXML is "it"
b) I could (shudders!), but it'd still be doing the data retrieval from the server (and the network traffic as far as the XSLT processor)

Daniel Cai

@danielcai_twitter

@MelesVolans_twitter my name is Daniel Cai, I am with KingswaySoft, and want to answer your question as Daryl has looped me in this thread. Those name, type attributes are a bit noisy, but they are the way how CRM queries works. We don't use REST style queries yet, it is something that we will be looking into. REST query would sure end up with less bandwidth consumption mainly because of the message format (JSON vs XML), but not too sure if those attributes will be suppressed though.

TheFlyingBadger

@MelesVolans_twitter

@danielcai_twitter - thanks for the reply (and thanks to @daryllabar for pinging him!). I'm going nicely with kingswaysoft, I'm just marginally paranoid about network traffic - particularly once we move our CRM to 365. Cheers , Jon (in Perth, WA - hence the unusual timing!)

Jonas Rapp

@rappen

:clap: Thanks @danielcai_twitter and @daryllabar for filling in for me! :)

kamilbrz

@kamilbrz

Hi guys, is that possible to move the rows to the columns:
for example:
col1 col2 col3
x1 a 66
x2 a 33
x1 b 21
x2 b 73
x1 c 58
x2 c 11

To:
col1 a b c
x1 66 21 58
x2 33 73 11

How to achieve this using FetchXML Builder?

Jonas Rapp

@rappen

Sorry, I don't see how that could be done using FetchXML. In SQL there are some features for that, but FetchXML is a much more limited query language.

davisblumentals

@davisblumentals

I need to filter a subgrid of Account entities that are related by Connection entities. I have no problem with filtering the Connections but I cannot find a way to filter on the accountid of the current Account record. Is there any way to do this?

Jonas Rapp

@rappen

I would say that this is solved by adding a subgrid (or associated view) for Connections, where you may add the filter that the related record shall be an account. The platform itself will handle filtering by "current" account.

davisblumentals

@davisblumentals

Thank you for your response. At first I used a subgrid of connections which worked very well. But then I referenced this subgrid in a portal entity form and and found that Dynamics 365 Portal DOES NOT SUPPORT connection subgrids. I then developed a Javascript web resource to filter the account subgrid but found that all accounts are loaded before reloading filtered accounts. Perhaps the solution is to use the connection subgrid in CRM and use a liquid template with fetchxml in the portal?

Jonas Rapp

@rappen

I would suggest you contact some portal gurus out there in regards to presenting connections in the portal. Try reaching out to Adoxio and/or Colin Vermander.