How to delete hidden and excluded rows by JSL

[#1]

Hello

I have a table, and some of the rows are hidden and excluded

I would like to delete them by JSL script

I tried this script, but nothing happened,

dt << Select Where (:Excluded == 1 | :Hidden == 1);

dt << Delete Rows ( );

Can you provide me a solution, please?

[#2 · Accepted solution]

Excluded and Hidden aren't columns  so you cannot refer to them with :Hidden and :Excluded. You can use functions though

Names Default To Here(1);

dt = Current Data Table();
dt << Select Where(Hidden() | Excluded()) << Delete Rows;

Edit:

One thing to note here is that this is checking for either hidden OR excluded not for both. If you want to check for both, you should use and operator (&).

dt << Select Where(Hidden() & Excluded()) << Delete Rows;