MikeTamoush
3 years agoQrew Commander
Formula Query Question HAS/CT
@Quick Base Junkie gives an amazing tutorial on Formula Queries. Also, previously in the community explained HAS vs CT (contains). The difference being, HAS looks at a multi select text and must match an entire part.
For example: Monday; Tuesday ; Wednesday
If you use contains Day, it will yield a result, if you use HAS day, it will not. You would need HAS Monday, or something like that.
Makes sense, but I can't seem to get it to work in practice.
I have a 'Classifications' multi select text field, which often only has one item select. In a good example, in one instance only the selection "Engineer" is selected in the multi select text field. My search query:
{14.CT.'Engineer'} returns a result as expected.
{14.HAS.'Engineer'} returns no result. I expected both to return the same result in this particular case. What am I misunderstanding?
ā
------------------------------
Mike Tamoush
------------------------------
For example: Monday; Tuesday ; Wednesday
If you use contains Day, it will yield a result, if you use HAS day, it will not. You would need HAS Monday, or something like that.
Makes sense, but I can't seem to get it to work in practice.
I have a 'Classifications' multi select text field, which often only has one item select. In a good example, in one instance only the selection "Engineer" is selected in the multi select text field. My search query:
{14.CT.'Engineer'} returns a result as expected.
{14.HAS.'Engineer'} returns no result. I expected both to return the same result in this particular case. What am I misunderstanding?
ā
------------------------------
Mike Tamoush
------------------------------