nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

IF statement for a constraint

V1212

Im trying to create a constraint where if street_status=1 then the street_id must be null.

I tried this statement but I get an error message each time I try to update street_status or street_id

if ($feature.street_status==1 && $feature.street_id==null)

return true;

else

return false;

Thanks in advance!

Najděte více příspěvků označených jako

Accepted answers

HusseinNasser2

The constraint rule does the following: Only allow features to be edited/created when their status is 1 and the street_id is null. Any other value, fail the edit which is what you are experiencing.

You might want to define your logic more explicitly. I'm assuming you want to ONLY fail when the status is 1 AND the street_Id is not NULL.

You can specify your logic this way.

if ($feature.street_status==1 && $feature.street_id != null) 

return false;

else 

return true;

MyProject1.gdb.zip

JohannesLindner

Probably you missed the curly brackets when copying the code, but still:

if ($feature.street_status==1 && $feature.street_id==null) {
  return true;
}
return false;

The problem with this code is the following: If you are inserting a street with street_status 2, it will return false, because you only check for street_status 1 and return false otherwise. This should work in those cases:

if ($feature.street_status==1 && $feature.street_id!=null) {
  return false;
}
return true;

This defaults to returning true and only blocks the insert/edit on the combination you don't want.

Other things to check:

As Chris said: Is street_status numeric?
Instead of the null check, you could try IsEmpty($feature.street_id)

All comments

V1212

Thanks for the help.

I didn't realized that street_status wasn't numeric.

V1212

Im getting the constraint popup when I change the street_status to any value.

Thanks!

HusseinNasser2

The constraint rule does the following: Only allow features to be edited/created when their status is 1 and the street_id is null. Any other value, fail the edit which is what you are experiencing.

You might want to define your logic more explicitly. I'm assuming you want to ONLY fail when the status is 1 AND the street_Id is not NULL.

You can specify your logic this way.

if ($feature.street_status==1 && $feature.street_id != null) 

return false;

else 

return true;

MyProject1.gdb.zip

JohannesLindner

Probably you missed the curly brackets when copying the code, but still:

if ($feature.street_status==1 && $feature.street_id==null) {
  return true;
}
return false;

if ($feature.street_status==1 && $feature.street_id!=null) {
  return false;
}
return true;

This defaults to returning true and only blocks the insert/edit on the combination you don't want.

Other things to check:

As Chris said: Is street_status numeric?
Instead of the null check, you could try IsEmpty($feature.street_id)

ChrisGAEG

Hi there,

What error are you getting? Is street_status a numeric field?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.