Queries

IdEnte = uuid.UUID('ef4c85d9-ea09-484f-b4f2-a3f2dc7e43b5') session = Database.get_session() query = session.query(AnalysisElementModel).filter(AnalysisElementModel.OrganizationId.eq(IdEnte)) query = query.filter(AnalysisElementModel.Name.like('%Area%')) exit()

IdTrattamento = uuid.UUID('94cfc699-09c4-4356-83fa-612ac86cf8f1') module-attribute

IdPDV = uuid.UUID('B6086AF3-BEFC-46CA-8D02-0002C1DB8DAE')

item = session.get(CategoryPropertyValues_AnalysisElements,IdPDV)

session = Database.get_session() module-attribute

filter_by = [dict(field_name='ProcedureModel.OrganizationUnits', operator='any', field_value={ 'field_name': 'OrganizationUnitModel.Name', 'operator': 'equals', 'field_value': 'Unità Org 1' })]