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 notifications@github.com 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 https://github.com/BNHM/AmphibiaWebDiseasePortal/issues/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 https://github.com/biocodellc/geome-db/issues/47