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>

No comments:

Post a Comment

Use Case: Managing Different Public Holiday Schedules for Different Segments of the Workforce

Use Case: Managing Different Public Holiday Schedules for Different Segments of the Workforce Organizations with diverse operational model...