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

Swift 4 - func physicsWorld not invoked on collision? The Next CEO of Stack OverflowHow to call Objective-C code from Swift#ifdef replacement in the Swift language@selector() in Swift?#pragma mark in Swift?Swift for loop: for index, element in array?dispatch_after - GCD in Swift?Swift Beta performance: sorting arraysSplit a String into an array in Swift?The use of Swift 3 @objc inference in Swift 4 mode is deprecated?How to optimize UITableViewCell, because my UITableView lags

Access current req object everywhere in Node.js ExpressWhy are global variables considered bad practice? (node.js)Using req & res across functionsHow do I get the path to the current script with Node.js?What is Node.js' Connect, Express and “middleware”?Node.js w/ express error handling in callbackHow to access the GET parameters after “?” in Express?Modify Node.js req object parametersAccess “app” variable inside of ExpressJS/ConnectJS middleware?Node.js Express app - request objectAngular Http Module considered middleware?Session variables in ExpressJSAdd properties to the req object in expressjs with Typescript