XDS issue in D365.

(0) Share

Report

Posted on by VermaMC

471

Hi, I have created a policy, which restricts the user to see only a specific retail store for the role "Retail Store manager".

0842.Security.JPG

However, when I try to restrict the data in Retail statements by adding RetailStatementTable and RetailTransactionTable to the policy. It is removing all the data.

please guide me in this.

Regards,

MC verma

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Chiranjeevim7,

Can you please confirm that users with Retail Store manager role can see only allowed stores ? Because if they cannot see any there is an issue with a query and it restricts them from seeing all stores and all transactions.

Trace parser is usually helpful with XDS issues, it allows you to capture SQL query and analyze it.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Chiranjeevim,

Can you also provide information about the query which is used for this security policy?

Was this reply helpful? Yes No
VermaMC 471 on at

Like (0)

Report
Copy link

Link copied!

Thanks ievgen and Andre.

The users with retail store manager can see only those stores which are assigned to them.

Let me share the query to you.

Query:

Temp Table:

XDS method:

public RefreshFrequency XDS()
{
xxx_RetailStoreSecurityTableTmp retailStoreSecurityTableTmp;
RetailStoreTable retailStoreTable;
RetailStoreAddressBook retailStoreAddressBook;
DirAddressBookParty dirAddressBookParty;
DirPersonUser dirPersonUser;

unchecked(Uncheck::XDS)
{
SecurityRights rights = SecurityRights::construct();

rights.populateSelectableCompanies();

while select retailStoreTable
exists join retailStoreAddressBook
where retailStoreAddressBook.StoreRecId == retailStoreTable.RecId
exists join dirAddressBookParty
where dirAddressBookParty.AddressBook == retailStoreAddressBook.AddressBook
exists join dirPersonUser
where dirPersonUser.PersonParty == dirAddressBookParty.Party
&& dirPersonUser.User == curUserId()
{
retailStoreSecurityTableTmp.StoreNumber = retailStoreTable.StoreNumber;
retailStoreSecurityTableTmp.insert();
}
}
return RefreshFrequency::PerSession;
}

Please let me know if any thing else needed.

Regards,

MC Verma

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Verma MC,

Query looks ok for me. Can you please follow my previous advice and use trace parser \sql profiler to get actual SQL query ? It's the easiest way to find what is wrong.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Verma,

Can you indicate if you have setup and assigned address books? The query is filtering on this feature.

Was this reply helpful? Yes No