Database custom filtering items based on string + numeric fields per item

Need help Database
1

Hi folks!
I’m facing a difficult database filter to perform. Let me explain the use case:

  • I have a thing on database called “Skill” having the fields “name” (text) and “years of experience” (number) associated to a candidate. So each candidate has a list of these skills.
  • I want to apply the next filter: “skill 1 >= X years” OR “skill 2 >= Y years”, like “Python >= 3 years” OR “AWS >= 1 year”.
  • And the expected result should be all the candidates having “Python” and “AWS” as well as accomplishing the years of experience per skill.

NOTE: The filter input data could be like lists of texts in JSON format like [“{"skill": "Python", "years": 3}”, …], and thanks to JSON Manipulator plugin :slight_smile: I can read it. But I’ve discarded creating temporal Things since it’s just a filtering matter, not database interaction should be involved for performance issues.

Although selecting candidates by skill name is so trivial, I have no idea how to filter at the same time by years of experience.

Any clue on that?