How to get the equivalent of combinig [contains] and [in] operators in the same query?

Output with the same length always

Are there any OR challenges that are similar to kaggle's competitions?

From where do electrons gain kinetic energy through a circuit?

Why is su world executable?

Meaning and structure of headline "Hair it is: A List of ..."

Replacing old plug-in 220V range with new hardwire 3-wire electric cooktop: remove outlet or add a plug?

Vegetarian dishes on Russian trains (European part)

Get file name and directory in .vimrc file

Are unaudited server logs admissible in a court of law?

Why don't modern jet engines use forced exhaust mixing?

Reducing contention in thread-safe LruCache

Tikz: The position of a label change step-wise and not in a continuous way

What's a good pattern to calculate a variable only when it is used the first time?

Why should P.I be willing to write strong LOR even if that means losing a undergraduate from his/her lab?

How to open terminal automatically when ubuntu boots up?

Eric Andre had a dream

If it isn't [someone's name]!

How do the Durable and Dwarven Fortitude feats interact?

Why do aircraft leave cruising altitude long before landing just to circle?

Why can't I see 1861 / 1871 census entries on Freecen website when I can see them on Ancestry website?

Parse a simple key=value config file in C

What is the opposite of "hunger level"?

What exactly happened to the 18 crew members who were reported as "missing" in "Q Who"?

How to render "have ideas above his station" into German



How to get the equivalent of combinig [contains] and [in] operators in the same query?







.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















So I have a field that's a multi-choice on the Directus back end so when the JSON comes out of the API it's a one-dimensional array, like so:






"field_name": [
"",
"option 6",
"option 11",
""
]





(btw I have no idea why all these fields produce those blank values, but that's a matter for another day)



I am trying to make an interface on the front end where you can select one or more of these values and the result will come back if ANY of them are found for that record. Think of it like a tag list, if the item has just one of the values it should be returned.



I can use the [contains] operator to find if it has one of the values I'm looking for, but I can only pass a single value, whereas I need all that have either optionX OR optionY OR optionZ. I would basically need a combination of [contains] and [in] to achieve what I'm trying to do. Is there a way to achieve this?



I've also tried setting the [logical] operator to OR, but then that screws up the other filters that need to be included as AND (or I'm doing something wrong). Not to mention the query gets completely unruly.



Help?










share|improve this question



















  • 1





    The "blank" items are likely due to the value being wrapped with the delimiter. You can disable this by turning off the wrapWithDelimiter interface option.

    – RANGER
    Mar 27 at 14:51

















1















So I have a field that's a multi-choice on the Directus back end so when the JSON comes out of the API it's a one-dimensional array, like so:






"field_name": [
"",
"option 6",
"option 11",
""
]





(btw I have no idea why all these fields produce those blank values, but that's a matter for another day)



I am trying to make an interface on the front end where you can select one or more of these values and the result will come back if ANY of them are found for that record. Think of it like a tag list, if the item has just one of the values it should be returned.



I can use the [contains] operator to find if it has one of the values I'm looking for, but I can only pass a single value, whereas I need all that have either optionX OR optionY OR optionZ. I would basically need a combination of [contains] and [in] to achieve what I'm trying to do. Is there a way to achieve this?



I've also tried setting the [logical] operator to OR, but then that screws up the other filters that need to be included as AND (or I'm doing something wrong). Not to mention the query gets completely unruly.



Help?










share|improve this question



















  • 1





    The "blank" items are likely due to the value being wrapped with the delimiter. You can disable this by turning off the wrapWithDelimiter interface option.

    – RANGER
    Mar 27 at 14:51













1












1








1


1






So I have a field that's a multi-choice on the Directus back end so when the JSON comes out of the API it's a one-dimensional array, like so:






"field_name": [
"",
"option 6",
"option 11",
""
]





(btw I have no idea why all these fields produce those blank values, but that's a matter for another day)



I am trying to make an interface on the front end where you can select one or more of these values and the result will come back if ANY of them are found for that record. Think of it like a tag list, if the item has just one of the values it should be returned.



I can use the [contains] operator to find if it has one of the values I'm looking for, but I can only pass a single value, whereas I need all that have either optionX OR optionY OR optionZ. I would basically need a combination of [contains] and [in] to achieve what I'm trying to do. Is there a way to achieve this?



I've also tried setting the [logical] operator to OR, but then that screws up the other filters that need to be included as AND (or I'm doing something wrong). Not to mention the query gets completely unruly.



Help?










share|improve this question














So I have a field that's a multi-choice on the Directus back end so when the JSON comes out of the API it's a one-dimensional array, like so:






"field_name": [
"",
"option 6",
"option 11",
""
]





(btw I have no idea why all these fields produce those blank values, but that's a matter for another day)



I am trying to make an interface on the front end where you can select one or more of these values and the result will come back if ANY of them are found for that record. Think of it like a tag list, if the item has just one of the values it should be returned.



I can use the [contains] operator to find if it has one of the values I'm looking for, but I can only pass a single value, whereas I need all that have either optionX OR optionY OR optionZ. I would basically need a combination of [contains] and [in] to achieve what I'm trying to do. Is there a way to achieve this?



I've also tried setting the [logical] operator to OR, but then that screws up the other filters that need to be included as AND (or I'm doing something wrong). Not to mention the query gets completely unruly.



Help?






"field_name": [
"",
"option 6",
"option 11",
""
]





"field_name": [
"",
"option 6",
"option 11",
""
]






directus






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Mar 27 at 13:21









LazarLazar

564 bronze badges




564 bronze badges










  • 1





    The "blank" items are likely due to the value being wrapped with the delimiter. You can disable this by turning off the wrapWithDelimiter interface option.

    – RANGER
    Mar 27 at 14:51












  • 1





    The "blank" items are likely due to the value being wrapped with the delimiter. You can disable this by turning off the wrapWithDelimiter interface option.

    – RANGER
    Mar 27 at 14:51







1




1





The "blank" items are likely due to the value being wrapped with the delimiter. You can disable this by turning off the wrapWithDelimiter interface option.

– RANGER
Mar 27 at 14:51





The "blank" items are likely due to the value being wrapped with the delimiter. You can disable this by turning off the wrapWithDelimiter interface option.

– RANGER
Mar 27 at 14:51












0






active

oldest

votes










Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55378264%2fhow-to-get-the-equivalent-of-combinig-contains-and-in-operators-in-the-same%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes




Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.







Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.



















draft saved

draft discarded
















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55378264%2fhow-to-get-the-equivalent-of-combinig-contains-and-in-operators-in-the-same%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현