Hola Jason, si no planeas usar multitenant. Te será útil crear una tabla adicional. Ejemplo:
zArea la cual contenga los siguientes campos:
- id
- nombre
Seguido puedes agregar cómo Columna a la tabla pcat (prob_category) y en la tabla cnt el campo zArea SREL zArea
Para finalizar crear una restricción cómo sigue:
Tipo view
Tabla Call_Req
Criterio category.zArea = @root.id.zArea
Si tienes dudas me consultas.
saludos,
Fabian.
------------------------------
[Designation]
[City]
------------------------------
Original Message:
Sent: 07-28-2020 10:09 AM
From: Jason Lara
Subject: Data partition - Restrict tickets view
Hello,
Right now i only have TI using SDM and now other area is going to use it to create work on tickets.
But i want to restrict that other areas so they can't see TI tickets even if they have the number. Which restriction can i set on a data partition?
Regards.