Can we use SysTableBrowser with all dataareaid

(0) Share

Report

Posted on by Tony zhong

901

Hello guys,

I used to check records in table with SysTableBrowser, an we use it to view all data area id / company ?

I tried to remove the ?cmp=.... but then it will added again.

Thanks.

I have the same question (1)

All responses (5)

Answers (1)

Suggested answer

ergun sahin 8,826 Moderator on at

Like (2)

Report

Not possible. Even if you delete it, it will add the default value in the user.

community.dynamics.com/.../the-url-parameters

Was this reply helpful? Yes No
Tony zhong 901 on at

Like (0)

Report

Hi Ergun,

Thanks for confirming, so that's mean the only way is directly to AXDB from SSMS then ?

Thanks

Was this reply helpful? Yes No
Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report

Hi Tony

It depends, which table you are checking, if the table is not saving the data as per company then it will show all company data to you, and if the table is saving records company-wise then the table browser shows you data accordingly.

You can verify with the table where the Application saving the data globally. Like MainAccount.

Was this reply helpful? Yes No
Tony zhong 901 on at

Like (0)

Report

Hi Sohail,

Yes, the table I'm viewing sometime including "save data per company" , but I still want to see it as whole (all companies).

This is mainly for checking data faster, so for example you want to see a product released to how many companies. I know there is a form for it, but to see in the SysTableBrowser like sometime faster, and also that is only for my example.

Thanks

Was this reply helpful? Yes No
Verified answer

Pete Alberts 3,542 on at

Like (1)

Report

I have a solution for you, but it is not good design. In any case it should help you. Create a View. Root data source CompanyInfo (or DataArea) and then join your table on DataAreaId. Pull all your fields through into the view fields. Then you can see all of them at the same time :) That is for dev.

If this is supposed to be a functional solution you can build a form (everything as usual) and then set the "Cross company auto query" property on the DS to yes.

Was this reply helpful? Yes No