Dynamics Community Forum Thread Details

WorkSpace Tile Count

I have a custom workspace form and it has tiles and filters
one of the filter is resource
and one of the tile is Planned production order.

Now the tile shows count of std form planned production order (form has count 397)
and when i click the tile this same std form opens.

Now I have attached a Query to tile to get count
in query I have added main DS ReqPo and its child DS InventDim, ReqTrans, ReqPlanVersion (all by inner join to ReqPo)

now the count comes 397

but when I attach ReqRouteJob to ReqTrans by inner join count comes 748
by outer 888
by exists 257
non exists 140
i am not getitng the default count 397

But when i change the filter i.e add a value in resource filter the count tht gets updated is proper.

Why this DS I added coz on the std form when i select a record and click on btn job in action pane a form opens with DS ReqRouteJob where there is a field WrkCtrId which range is applied to resource

so i added it and relation is ReqPlanVersion and ReqTrans RefId and ReqRouteJob ReqPold this is std relation.

Can u suggest a way out tht default count 397 same as record in form and then when i change the filter acc ot value entered count should change?

Categories:

Dynamics 365 Supply Chain Management

I moved the thread to the right forum, fixed dozen typos and gave tables and fields correct letter casing. Unfortunately, it's still difficult to understand.

CU14051612-0, could you please read your text, split it to sentences and fix places that don't say what you intended? Next time, please do better job when writing your message; we can't help you if we can't understand your problem. Note that a spell check can detect many issues for you.

Regarding your actual problem, I'm surprised that you've never mentioned any query string. You should use them to compare the queries (on the form and on the tile). If I understand your problem correctly, you're trying to make the same query but you failed and because you look just at the data returned, not the acual queries, you have no idea how your query differs. Comparing them will tell you the differences and you'll know what to fix.

Quick Links