Can we use SysTableBrowser with all dataareaid

(0) Share

Report

Posted on by Tony zhong

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.

All responses (5)

Answers (1)

Suggested answer

ergun sahin on at

Like (2)

Report

RE: Can we use SysTableBrowser with all dataareaid

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

community.dynamics.com/.../the-url-parameters
Tony zhong on at

Like (0)

Report

RE: Can we use SysTableBrowser with all dataareaid

Hi Ergun,

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

Thanks
Suggested answer

Sheikh Sohail on at

Like (0)

Report

RE: Can we use SysTableBrowser with all dataareaid

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.
Tony zhong on at

Like (0)

Report

RE: Can we use SysTableBrowser with all dataareaid

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
Verified answer

Pete Alberts on at

Like (1)

Report

RE: Can we use SysTableBrowser with all dataareaid

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.