Christian_Glaser_7453

Search for JOBS object where the login in empty

Discussion created by Christian_Glaser_7453 on Dec 6, 2017
Latest reply on Dec 19, 2017 by Josef_Scharl_103
Question:
Is is possible to find all JOBS objects where the field LOGIN is empty

Answer:
select oh.oh_name, oh.oh_client from JBA, OH
where jba_logindst is null
and oh.oh_idnr = jba.jba_oh_idnr
and oh.oh_client = '***'
order by oh.oh_client, oh.oh_name;

Outcomes