Adding OR condition (property) in crm_objects query

[CristianSabogal]

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

[Indra · Accepted solution]

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) %}

[CristianSabogal]

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) %}

[Jaycee_Lewis]

Hi, @CristianSabogal 👋 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