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. ARICA | 50 |
The idea it’s to build dimensions bases in expression to build this. Is it possible ?
Thanks a lot.