query range on fin.dim.

select * from worker exists join personUser
  where worker.Person == personUser.PersonParty
	&& personUser.User == curUserId();

select DefaultDimension from HcmEmployment where HcmEmployment.Worker == worker.RecId;
//Department = HcmWorkerHelper::getPrimaryDepartmentRecId(HcmWorkerLookup::currentWorker());
OMOperatingUnit OMOperatingUnit;
OMOperatingUnit = HcmWorkerHelper::getPrimaryDepartment(HcmWorkerLookup::currentWorker());
Department = OMOperatingUnit.OMOperatingUnitNumber;
//Info(Department);
//Department = DimensionAttributeValueSetStorage::find(HcmEmployment.DefaultDimension).getDisplayValueByDimensionAttribute(DimensionAttribute::findByName("Department").RecId);
//  Info(Department);
qbdsdimensionAttributeValueSet = purchTable_ds.query().dataSourceTable(tableNum(PurchTable)).addDataSource(tableNum(dimensionAttributeValueSet));

qbdsdimensionAttributeValueSet.addLink(fieldNum(PurchTable,DefaultDimension),
                                       fieldNum(dimensionAttributeValueSet,RecId));
qbdsdimensionAttributeValueSet.joinMode(JoinMode::ExistsJoin);
qbdsdimensionAttributeValueSet.relations(true);
qbdsdimensionAttributeValueSet.fetchMode(QueryFetchMode::One2One);

qbdsdimensionAttributeValueSetItemView = purchTable_ds.query().dataSourceTable(tableNum(PurchTable)).addDataSource(tableNum(dimensionAttributeValueSetItemView));
qbdsdimensionAttributeValueSetItemView.addLink(fieldNum(PurchTable,DefaultDimension),
                                               fieldNum(dimensionAttributeValueSetItemView,DimensionAttributeValueSet));
qbdsdimensionAttributeValueSetItemView.joinMode(JoinMode::ExistsJoin);
qbdsdimensionAttributeValueSetItemView.relations(true);
qbdsdimensionAttributeValueSetItemView.fetchMode(QueryFetchMode::One2One);
qbdsdimensionAttributeValueSetItemView.addRange(fieldNum(dimensionAttributeValueSetItemView,DisplayValue)).value(Department);

qbdsDimensionAttribute = qbdsdimensionAttributeValueSetItemView.addDataSource(tableNum(DimensionAttribute));
qbdsDimensionAttribute.addLink(fieldNum(dimensionAttributeValueSetItemView,DimensionAttribute),
                               fieldNum(DimensionAttribute,RecId));
qbdsDimensionAttribute.joinMode(JoinMode::ExistsJoin);
qbdsDimensionAttribute.relations(true);
qbdsDimensionAttribute.fetchMode(QueryFetchMode::One2One);
qbdsDimensionAttribute.addRange(fieldNum(DimensionAttribute,Name)).value("DEPARTMENT");