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; } } }

Add constraint comparing another field and NULL

Damian

Hi, I have two integer fields, "FIELD A" and "FIELD B". I am trying to add a constraint on "Field A" that meets the following conditions:

If "Field B" IS NULL, "Field A" can be any value (including NULL)

If "Field B" IS NOT NULL, "Field A" must be greater than "Field B"

Can anyone assist with the syntax please?

Regards, Damian

Vind meer berichten getagd met

Accepted answers

dougbrowning

You just want it to eval to true so just give it a 1.

if(string-length(${Field_B}) > 0,${Field_A} > ${Field_B},1)

All comments

Damian

Ahh, many thanks Doug.

dougbrowning

You just want it to eval to true so just give it a 1.

if(string-length(${Field_B}) > 0,${Field_A} > ${Field_B},1)

Damian

Thank you gents, however the answer still alludes me. The closest I can come up with is the following:

if(string-length(${Field_B}) > 0,${Field_A} > ${Field_B},*** any number or NULL ***)

Any further assistance would be greatly appreciated.

JamesTedrick

Adding on to Doug's comment, use the function string-length(${q}) > 0 to test for null - all question types evaluate to a string length of 0 when null.

dougbrowning

In 123 Null is empty string. So compare to '' or "".

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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