Innofactor/FetchXMLBuilder

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

Syed Sajid Hussain

@SyedSajid08_twitter

yes I did find it thanks!

but couple of issues I found when I tried to run that code

when calling the AddLink, I think it's adding the fields in wrong order

like i had to change this

var qe_salesorder = qe.AddLink("salesorder", "customerid", "contactid", JoinOperator.LeftOuter);

to this

var qe_salesorder = qe.AddLink("salesorder", "contactid", "customerid", JoinOperator.LeftOuter);

and then it worked fine

not sure if this is a bug...or something I am missing

Jonas Rapp

@rappen

Known issue, that sometimes occur... :( #105

Daryl LaBar

@daryllabar

What information do you collect, how do you collected it, and what do you plan on doing with it? I'm asking for a "friend" ;)

Jonas Rapp

@rappen

Are you talking about the "Statistics" that I humbly ask users to accept?

Daryl LaBar

@daryllabar

No, I'm talking about "Statistics" that you automatically enable and allow users to opt out...

Jonas Rapp

@rappen

Well, you know I am not that good with English, we probably mean the same thing ;)
It's all available in the code - open source! :D
Basically: open tool, execute query, open view, save view, etc.
No details, nothing about connection or data, nothing about e.g. which entity view was queried etc. Classic web logging service, so it stores location etc. But of course no browser features, as this is no browser.

Daryl LaBar

@daryllabar

So you record how many times they open a view, or save a view, or execute a query, but never what it actually is? I'm thinking about enabling something like this for the EBG, but I'm not sure what informatino I would care about

Jonas Rapp

@rappen

Exactly. Actually a simple http call similar to the js code you would embed to you web page, but with faked "url name" that instead is the name of the feature being performed. XTB core uses the same method (Mr T copied my code) to count plugin usage.

https://github.com/Innofactor/FetchXMLBuilder/blob/master/FetchXmlBuilder/AppCode/LogUsage.cs

Please don't use my tokens ;)

Daryl LaBar

@daryllabar

So it just records whatever data you give it? u, camefrom, etc. Do I have to login to see the stats, or can I view yours?

Jonas Rapp

@rappen

This one works for XTB statcounter.com/p10479559/popular/?guest_login=1&account_id=2309392&login_id=5&code=bd40204dbb949d0d2a9b206d6b70ffc6&&perpage=200

Not sure I have a gues login to mine...

*guest

Mine should be public http://statcounter.com/p10396418/summary/?guest=1

Daryl LaBar

@daryllabar

So the only thing you can record are the "pages" which you list as action?

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)

Where communities thrive

People

Repo info

Activity