SELECT DBI.USER_NAME,BASE_CONTEXT_NAME
FROM FF_DATABASE_ITEMS_VL DBI,
FF_USER_ENTITIES_VL USERENT,
FF_ROUTES_VL ROUTES,
FF_ROUTE_CONTEXT_USAGES RCU,
FF_CONTEXTS_VL CON
Where DBI.USER_ENTITY_ID = USERENT.USER_ENTITY_ID
AND USERENT.ROUTE_ID = ROUTES.ROUTE_ID
AND DBI.base_USER_name = <DBI Name>
AND ROUTES.ROUTE_ID = RCU.ROUTE_ID
AND CON.CONTEXT_ID = RCU.CONTEXT_ID
==========================================================
select FF.FORMULA_NAME, BASE_CONTEXT_NAME
ff_contexts_vl CON,
ff_ftype_context_usages FCU,
FF_FORMULA_TYPES_VL FT
WHERE FF.formula_type_id = FT.formula_type_id
AND FCU.FORMULA_TYPE_ID = FT.formula_type_id
AND CON.CONTEXT_ID = FCU.CONTEXT_ID
AND BASE_FORMULA_NAME LIKE <Formula Bas Name>
No comments:
Post a Comment