Does not start with query??

[prajaktanaik]

Hi All,

Is there any way I can have a query which filters out group names that start with 'OG'? There are almost more than 200 groups that I need to filter out using reference qualifier but not sure how to query it as we dont have any operator for that?

Appreciate your help on this.

Thanks in advance,

Prajakta

[Mark Roethof]

Hi there,

Have you had a look at encoded queries?

You could make a filter at lists, and simple copy the generated query. So also with a does not start query for example.

(active=true^incident_state!=6^short_descriptionNOT LIKEsomething)

Kind regards,
Mark

---

LinkedIn

[prajaktanaik]

Hi Mark,

Yes I tried above query but this will also remove any other group with contains OG, we just want to filter out the ones which start with OG.

Best Regards,

Prajakta

[Soumita3]

Hi Prajakta,

You need a query to filter out group name starting with 'OG', there is a query that states group name 'starts with'.

Please follow the screenshot.

 I hope this will solve your purpose.

Please mark the answer as correct/helpful if it suffice your query.

Thanks.
Soumita.

[DirkRedeker]

Hi

My answer is very late, but maybe not too late 🙂

I achieved to do something like a "DOES NOT START WITH" query, by adding TWO "BETWEEN" conditions, which ranges from (let's say) "A" to "IB" (and I wanted to leave out all starting with "IC") and another one starting with "ID" and going to nowhere.

This just filtered out what I was expecting.

Maybe that is also suitable here.

Let me know if that answers your question and mark my answer as correct and helpful.

BR

Dirk