Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Dynamic Validation per Table doesn't work if table is View.

Description

The Dynamic Validation per Table is working fine on standard tables. But it doesn't work if the table is view. For examle, if I create a simple Validation on M_Product as m_product.isactive='Y' it works fine on window Products. If I deactivate some of records, on next open the table has less products.. But When I switch the table type to view and switch back to Admin rule, all the products are viewed. - This is just an example for easy test, I use other - real views, where it would be fine to limit access to views too.

Environment

Attachments

5

Activity

Show:

Carlos Ruiz October 17, 2024 at 11:15 AM

Thanks , that's a good idea, reopening

Ladislav Nagy October 17, 2024 at 11:09 AM

then maybe in window Dynamic Validation per Table we can exclude views from Table dropdown

 

Carlos Ruiz October 17, 2024 at 10:10 AM

Thanks for adding the workaround.

Implementing a solution in core sounds too dangerous for breaking backward compatibility, so, I think we better close this ticket now that you documented a valid workaround.

Ladislav Nagy October 15, 2024 at 5:14 PM

If I have a real view in database, create idempiere table from that, and uncheck view checkbox-to act as a table and not view, it’s works as a charm with dynamic validation.

Carlos Ruiz October 11, 2024 at 2:06 PM

- that line is there since the fork from compiere.

Details

Assignee

Reporter

Labels

Affects versions

Priority

Created October 7, 2024 at 11:21 AM
Updated October 17, 2024 at 11:39 AM