XDS Policy query works with Tmp table but not with a regular table!

(1) Share

Report

Posted on by AbdullahAhmed_

521

I created a security policy with SalesTable as primary table and this is the query used for it:

I created a Tmp table that has one field only (SalesId) and it works fine and shows the data.. but when I created a regular table

with the same features.. It just doesn't show any data at all!

This is the code in the regular table methods:

public class XDSSalesTableRegular extends common
{
    private void setRangesForSalesTable()
    {
        SalesTable           salesTable;
        XDSSalesTableRegular xDSSalesTableRegular;
        DYNADDVTable         dYNADDVTable;
        
        if(DYNADDVTable::userExistInUsers(curUserId()))
        {
            delete_from xDSSalesTableRegular;

            insert_recordset xDSSalesTableRegular(SalesId)
                select SalesId from salesTable
                    where salesTable.CustGroup == 'Free Cust'
                    &&    salesTable.InventLocationId == '101011121';
        }
    }
    
    public RefreshFrequency xds()
    {
        unchecked(Uncheck::XDS)
        {
            this.setRangesForSalesTable();
        }

        return RefreshFrequency::PerSession;
    }
}

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Martin Dráb 239,996 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Your code makes little sense with a regular table, unless you limit the whole ERP system to a single user session. If there are two users, or even a single user with two sessions, the may block each other. For example, one user insert data to the table and before it gets used by XDS, it may get deleted by delete_from statement called from other user's session. This is simply a bad idea. In addition, it would be bad for performance.

Or if you're mean that you already have the table populated with data, then you don't need all the code to populate it again, therefore you should throw it away. Having the table in the XDS query is sufficient.

And if the table is temporary, you can throw away the delete_from statement, because the buffer will always be empty before you insert data into it.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 306,250 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi AbdullahAhmed,

As Martin mentioned, an XDS method on a regular table will not create the records for the security policy. Either you need to have a regular table prefilled with data or you have a temporary table with the XDS method. Note that on the SQL server per user a temporary table will be created with their sales order IDs.

Was this reply helpful? Yes No