[NSFW] Filter entity

@danyelconstantin231

I’m not sure I understand what are you trying to do. Do you want a dropdown on a page that contains data from CRM? You can build one easily with twig code where you can use either view or fetchxml to retrieve the data. Then loop over the results and build your control.

to view all the sistem views

Again, I’m not sure what are you trying to build, the dropdown with the contacts or dropdown that contains the list of system views for the contact entity.

HTH
George

’m not sure I understand what are you trying to do. Do you want a dropdown on a page that contains data from CRM? You can build one easily with twig code where you can use either view or fetchxml to retrieve the data. Then loop over the results and build your control.

Can you give a simple exemple, a simple code ?

Again, I’m not sure what are you trying to build, the dropdown with the contacts or dropdown that contains the list of system views for the contact entity.

I want to show a dropdown that contains the list of system views for the contact entity.
Can you give a simple exemple ?

Building dropdown from a view:

[msdyncrm_twig]
{% view entity="product" name="Web Product list" cache="PT2H" %}
<select>
  {% for recordId, record in entityview.rows %}
     <option value="{{record['productid'].value}}">{{record['name'].value}}</option>
  {% endfor %}
</select>
{% endview %}
[/msdyncrm_twig]

Retrieving all system views for an entity can be done with fetchxml using savedquery entity:

<fetch>
  <entity name="savedquery" >
    <attribute name="name" />
    <filter>
      <condition attribute="returnedtypecode" operator="eq" value="2" />
    </filter>
  </entity>
</fetch>

HTH
George

This is for the products list but if i need to show all the system views from the entity “contact” in a drop down list will be like this:

<fetch>
<entity name=”contact” >
<attribute name=”name” />
<filter>
<condition attribute=”returnedtypecode” operator=”eq” value=”2″ />
</filter>
</entity>
</fetch>

where “contact” is the entity ?

and then to be in a drop down i have to put this:

[msdyncrm_twig]
{% view entity=”contact” name=”contact” cache=”PT2H” %}
<select>
{% for recordId, record in entityview.rows %}
<option value=”{{record[‘productid’].value}}”>{{record[‘name’].value}}</option>
{% endfor %}
</select>
{% endview %}
[/msdyncrm_twig]