Showing posts with label Fast Formulas. Show all posts
Showing posts with label Fast Formulas. Show all posts

Thursday, 28 January 2021

SQL Query to Get Database Items and context

 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>