adding a conditional rule based on a value in a field?

[mkoo]

@jdeck88 Is it possible right now to add a Geome-db Rule based on a value in a field?
Specifically, if basisOfRecord= PreservedSpecimen, require values in collectionCode and catalogNumber (i.e. do not allow NULL)

I tried below but not quite enough!

RequireValueIfOtherColumn | ERROR | column: basisOfRecord  otherColumn: collectionCode
-- | -- | --

[jdeck88]

that rule only checks to see if a value exists in another column if a value is given in the first column (e.g. useful for latitude/longitude... both are needed). there is no rule to check for required values based on a particular value in a column.... though, i can see this as a good idea. can you make an issue in https://github.com/biocodellc/geome-db ? John

…

On Thu, Dec 10, 2020 at 5:07 PM Michelle Koo ***@***.***> wrote: @jdeck88 <https://github.com/jdeck88> Is it possible right now to add a Geome-db Rule based on a value in a field? Specifically, if basisOfRecord= PreservedSpecimen, require values in collectionCode and catalogNumber (i.e. do not allow NULL) I tried below but not quite enough! RequireValueIfOtherColumn | ERROR | column: basisOfRecord otherColumn: collectionCode -- | -- | -- — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#108>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAIZ3RIJSEUIAUQKTU74PDDSUFWEXANCNFSM4UV3BP6A> .

-- John Deck (541) 914-4739

[mkoo]

ok that's what I thought!
Done. new issue at biocodellc/geome-db#47