Hello,
we are upgrading to 8.0.2 from version 7 , we are facing a issue with one filter which will determine employees to be displayed on a page. The same condition is working in 7 with out any issues.
Condition is as shown below:
"uid_person in (select uid_person from Person where uid_personhead = '%useruid%' and ((CCC_EmployeeType is null Or CCC_EmployeeType in ('Agency','Bechtel','Contractor')) and isinactive=0)
union
select uid_person from person where (((CCC_EmployeeType='Contractor') or (CCC_EmployeeType in ('Agency','Bechtel',null) and isinactive=0)) and exists (select uid_person from personinorg where uid_person='%useruid%' and uid_org in (select uid_org from org where Ident_Org='Helpdesk' or Ident_Org='HR Admin')))
union
select uid_person from QERVEditEmployee where uid_personhead = '%useruid%'and CCC_EmployeeType='Contractor' and isinactive=0 and exists (select uid_person from personinorg where uid_person='%useruid%' and uid_org in (select uid_org from org where Ident_Org='Sponsor'))
union
select uid_person from Person where CCC_EmployeeType='Contractor' and isinactive=0 and exists (select uid_person from personinorg where uid_person='%useruid%' and uid_org in (select uid_org from org where Ident_Org='SISM'))
union
select uid_person from person where IsInActive=0 and exists (select uid_person from personinorg where uid_person='%useruid%' and uid_org in (select uid_org from org where Ident_Org='NOC' or Ident_Org='Security' or Ident_Org='ProjectIT' or Ident_Org='UAMReadAccess' or Ident_Org='Threat Management Team'))
union
/* Craft GBU Project Management groups - Start */
select uid_person from person where IsInActive=0 and CCC_EmployeeType='Craft'
and uid_person in (select uid_person from adsaccount
where
uid_adscontainer =
(select uid_adscontainer from adscontainer
where domaindisplayname='amers' and cn='Infra'
and
UID_ParentADSContainer =
(select uid_adscontainer from adscontainer
where domaindisplayname='amers' and cn='16_Craft_Users'))
)
and exists (select uid_person from personinorg where uid_person='%useruid%' and
uid_org in (select uid_org from org where Ident_Org='Craft Infra GBU Project Manager'))
union
select uid_person from person where IsInActive=0 and CCC_EmployeeType='Craft'
and uid_person in (select uid_person from adsaccount
where
uid_adscontainer =
(select uid_adscontainer from adscontainer
where domaindisplayname='amers' and cn='MM'
and
UID_ParentADSContainer =
(select uid_adscontainer from adscontainer
where domaindisplayname='amers' and cn='16_Craft_Users'))
)
and exists (select uid_person from personinorg where uid_person='%useruid%' and
uid_org in (select uid_org from org where Ident_Org='Craft MM GBU Project Manager'))
union
select uid_person from person where IsInActive=0 and CCC_EmployeeType='Craft'
and uid_person in (select uid_person from adsaccount
where
uid_adscontainer =
(select uid_adscontainer from adscontainer
where domaindisplayname='amers' and cn='OGC'
and
UID_ParentADSContainer =
(select uid_adscontainer from adscontainer
where domaindisplayname='amers' and cn='16_Craft_Users'))
)
and exists (select uid_person from personinorg where uid_person='%useruid%' and
uid_org in (select uid_org from org where Ident_Org='Craft OGC GBU Project Manager'))
union
select uid_person from person where IsInActive=0 and CCC_EmployeeType='Craft'
and uid_person in (select uid_person from adsaccount
where
uid_adscontainer =
(select uid_adscontainer from adscontainer
where domaindisplayname='amers' and cn='Power'
and
UID_ParentADSContainer =
(select uid_adscontainer from adscontainer
where domaindisplayname='amers' and cn='16_Craft_Users'))
)
and exists (select uid_person from personinorg where uid_person='%useruid%' and
uid_org in (select uid_org from org where Ident_Org='Craft Power GBU Project Manager'))
/* Craft GBU Project Management groups - End */
)"
--select uid_person from Person where uid_personhead = '%useruid%' and CCC_EmployeeType='Contractor' and isinactive=0 and exists (select uid_person from personinorg where uid_person='%useruid%' and uid_org in (select uid_org from org where Ident_Org='SISM' or Ident_Org='Sponsor'))--
To just check for HelpDesk role we changed it to below:
"UID_Person in (select uid_person from person where (((CCC_EmployeeType='Contractor') or (CCC_EmployeeType in ('Agency','Bechtel',null) and isinactive=0)) and exists (select uid_person from personinorg where uid_person='%useruid%' and uid_org in (select uid_org from org where Ident_Org='Helpdesk')))) - helpdesk role should return 44k entries we are seeing just 7
"
This new condition I snot taking effect in SQL logs I still see QERVEditEmployee table being queried, we restarted IIS service but still same result . Please help.