Thursday, 28 January 2021

Database Item and context Query

 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>