Adding OR condition (property) in crm_objects query

Developer Support CMS Development
1

Hi there,

How I can define the query string to filter by property_x but many values?

I’m trying this:

{% set query = crm_objects(“proyecto”, “hs_pipeline_stage=20346536 | hs_pipeline_stage=20346539&limit=100”, properties) %}

But, not working.

It seems to me inefficient to bring in this case the projects with the hs_pipeline_stage with id (20346536 and 20346539) with independent queries.

Thanks and regards,

Cristian Sabogal

2

Hi, @CristianSabogal :waving_hand: Thanks for reaching out! Let’s see if we can get the conversation going for you. Hey, @albertsg @Indra @Oezcan, do you have any suggestions or workarounds for @CristianSabogal?

Thank you! — Jaycee

3

Hi @CristianSabogal,

I haven’t tested this yet, but have you tried the following?


{% set query = crm_objects("proyecto", "&hs_pipeline_stage=20346536&hs_pipeline_stage=20346539&limit=100", properties) %}
4

Hi @Indra.

Yes I tried this:

{% set query = crm_objects("proyecto", "&hs_pipeline_stage=20346536&hs_pipeline_stage=20346539&limit=100", properties) %}

But doesn’t work. However I found one way to achieve it.

This works:

{% set query =crm_objects(“proyecto”,“hs_pipeline_stage__in=20346536,25271316,25266832&limit=100”, properties) %}