Answered

Display data from Dataverse in a page

(0) Share

Report

Posted on by jypy

Hi All !

I have a table called "Case". In this table, i ave a column called "Status Reason". We have 4 types of Status Reason : Resolved, In Progres, Incomplet and Submitted.

So for a given user (connected), I want to be able to count the number of each status of this user. See image:

----------------------------------------------------------------------------------------------------------------------------------------------

Please, i need your help!

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (2)

Sort by

jypy 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi All !
Please, i need your help!

Was this reply helpful? Yes No
domliu37 314 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jypy ,

Is this question Power Pages related? Really trying to understand what you asking here.

Cheers,
Dom

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jypy

you can use liquid to count. Example below

{% assign count = entities.country.size %} Total number of entries in the country table: {{ count }}

Official URL: click here

Apply some fetchxml with liquid to filter your case status condition or use Javascript/jquery to achieve your count.

Have fun.

Hope it helps.
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Lucas001 2,595 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @jypy,

I think @ragavanrajan already gave the correct approach.
If I understand you correctly you will need one filter which is set to the User and than one for each case. Depending on what you want to display.

If you want to later display that on your page use a html tag and insert the liquid variable inside, so that you can do further manipulation with Jquery etc.

--------------------------------------------------------------------------------------

Hope that helps.

If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.

Was this reply helpful? Yes No
Verified answer

jypy 30 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi All !
Thanks a lot for your answers.

here is my scripts whitch work well :
{% fetchxml incidentProblemSolved %} <fetch version="1.0" output-format="xml-platform" mapping="logical" aggregate='true'> <entity name="incident"> <attribute name="statuscode" alias="incidentcount" aggregate="count" /> <filter type="and"> <condition attribute="statuscode" operator="eq" value="5" /> </filter> </entity> </fetch> {% endfetchxml %} <resultset morerecords="0"> <result> <count>{{ incidentProblemSolved.results.entities.first.incidentcount }}</count> </result> </resultset>

So, do that for each column or filed select value.

Was this reply helpful? Yes No
Verified answer

jypy 30 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks a lot for your answers.
here is my scripts whitch work well :

{% fetchxml incidentProblemSolved %} <fetch version="1.0" output-format="xml-platform" mapping="logical" aggregate='true'> <entity name="incident"> <attribute name="statuscode" alias="incidentcount" aggregate="count" /> <filter type="and"> <condition attribute="statuscode" operator="eq" value="5" /> </filter> </entity> </fetch> {% endfetchxml %} <resultset morerecords="0"> <result> <count>{{ incidentProblemSolved.results.entities.first.incidentcount }}</count> </result> </resultset>
So, do that for each column or filed select value.

Was this reply helpful? Yes No