Hi community,
I’m working in a project for a Chile Police and I need to know if it’s possible to build a hierarchy in Deepsee like Zone- Prefecture – Comisaria – Destacamentos (there are 4 levels of police units) , but these information are only in one table that has the code, the father ,description and UnitType. (it’s recursive) . Example:
|
UNI_CODIGO |
UNI_PADRE |
UNI_DESCRIPCION |
UNI_TIPOUNIDAD |
|
1 |
20 |
OTRA REPARTICION |
|
|
10 |
2.380 |
38A. COM. PUENTE ALTO |
50 |
|
20 |
|
DIR.NAC.SEGUR.Y ORDEN PUBLICO |
10 |
|
30 |
8.855 |
TENENCIA CARRETERA ARICA |
70 |
|
40 |
8.740 |
1RA. COM. ARICA (AGR) |
40 |
|
45 |
40 |
1RA. COM. |


This error appears:



