Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Is it possible to run query on a Form implemented as Webresource HTML and .js? The form will be part of MS CRM Portal.

Posted on by 290

Hello!

I would like to query e.g. all records from custom table which has type First name of the current user in MS CRM Portal. Basically, I have a custom table which is related to Contact and for each field, I have some values in this table, values in this table are distinguished by the type which equals to the name of the field in Contact table. I am thinking to do it in a way to add webresource to the form and then query the data with the javascript and populate the data in the HTML table. 

I would like to achieve:

Field Value Date User
First Name Test 1 11.12.2018 Miha
  Test 2  11.12.2018 Miha
Last Name Test 1 11.12.2018 Miha
  Test 2  11.12.2018 Miha
  Test 3 11.12.2018 Miha
  Test 4 11.12.2018 Miha

I think that this functionality can not be achieved with out of the box features (subgrids can not be aligned with the one field, right? Or I am wrong?

BR,

MIha

*This post is locked for comments

  • Miha Mocnik Profile Picture
    Miha Mocnik 290 on at
    RE: Is it possible to run query on a Form implemented as Webresource HTML and .js? The form will be part of MS CRM Portal.

    Thank you!

  • Suggested answer
    Tino Rabe Profile Picture
    Tino Rabe 650 on at
    RE: Is it possible to run query on a Form implemented as Webresource HTML and .js? The form will be part of MS CRM Portal.

    Hi Miha,

    I am not aware of updating the data via this way.

    Hence, you only update data by submitting them via the form submit.

  • Miha Mocnik Profile Picture
    Miha Mocnik 290 on at
    RE: Is it possible to run query on a Form implemented as Webresource HTML and .js? The form will be part of MS CRM Portal.

    Thank you! What about if I would like to update the data returned using fetchxml or json? Is it possible? I couldn't find any example..

  • Verified answer
    Tino Rabe Profile Picture
    Tino Rabe 650 on at
    RE: Is it possible to run query on a Form implemented as Webresource HTML and .js? The form will be part of MS CRM Portal.

    Hi MIha,

    yes there is such possibility.

    Check out these post: 

    Don't forget about Entity Permissions as the output is secured by those.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans