Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fetch XML complex #1

Open
kiquenet opened this issue Oct 19, 2016 · 0 comments
Open

Fetch XML complex #1

kiquenet opened this issue Oct 19, 2016 · 0 comments

Comments

@kiquenet
Copy link

kiquenet commented Oct 19, 2016

I'm newbie with CRM, and now I have discovered your great compenent Fluent. For me, it's great using Fluent and not more large big strings Fetch XML.

Is your component valid for this large string Fetch XML?

Using 2 link-entity nested with filter?

<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
                                        <entity name='campaign'>
                                        <attribute name='campaignid'/>                    
                                        <attribute name='name'/>
                                <attribute name='new_imagenweb'/>
                                        <attribute name='new_bases'/>
                                 <attribute name='description'/>
                                 <attribute name='proposedend'/>
                                  <attribute name='proposedstart'/>
                                   <attribute name='statuscode'/>
                                  <attribute name='new_tipodecampanaid'/>
                                         <attribute name='new_fechadefinalizaciondiferida'/>
                                        <attribute name='new_codigocampaaaire'/>
                                        <attribute name='new_enlazaclientes'/>
                                        <attribute name='new_fechapublicacion'/>
                                        <attribute name='new_documentosaprobados'/>
                                        <attribute name='new_tipodevisualizacion'/>  
                                        <attribute name='qes_subcategoria'/>
                                        <attribute name='qes_visibleenportal'/>
                                        <attribute name='qes_visiblecorredor'/>
                                        <attribute name='qes_descripcioncorta'/>
                                        <attribute name='new_fechafincomunicacion'/>

                                            <filter type='and'>
                                                   <condition attribute='qes_visibleenportal' operator='eq' value='1'/>
                                            </filter>
                                            <order attribute='name' descending='false'/>
                                            <link-entity name='new_mediadorcampana' from='new_campanaid' to='campaignid' alias='ad'>
                                                <link-entity name='lead' from='leadid' to='new_mediadorid' alias='ae'>
                                                        <filter type='and'>
                                                            <condition attribute='new_cpc' operator='eq' value='MiVariable1'/>
                                                        </filter>
                                                </link-entity>
                                                <filter type='and'>
                                           <condition attribute='qes_visibleportal' operator='eq' value='1'/>
                                         </filter>

                                            </link-entity>
                                        </entity>
                                    </fetch>

Full Fetch XML in http://pastebin.com/BrvwNWDv

And attributes with alias as

<attribute name='rsg_codigodeaire' alias='new_codigocampaaaire'/>

Suggestions: Maybe working together with https://github.com/Innofactor/FetchXMLBuilder.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant