# Conditional in Ecto.query

**URL:** <https://forum.elixirforum.com/t/conditional-in-ecto-query/17541>\
**Category:** Questions\
**Tags:** ecto, ecto-query, pipe-operator\
**Created:** [October 26, 2018, 10:07am UTC](https://forum.elixirforum.com/t/conditional-in-ecto-query/17541 "2018-10-26T10:07:08Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![peerreynders](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/peerreynders/32/5826_2.png) [@peerreynders](https://forum.elixirforum.com/u/peerreynders)\
**Post date:** [October 26, 2018, 11:05am UTC](https://forum.elixirforum.com/t/conditional-in-ecto-query/17541/2 "2018-10-26T11:05:52Z")

</div>

```elixir
|> (fn(n) -> tgl != "" |> where([schema], like(schema.tgl, ^tgl)) || "" end).()``

```

looks to me that you were trying to do something like this

```elixir
|> (fn(query) -> 
     case tgl do
        "" -> query 
        _ -> where(query, [schema], like(schema.tgl, ^tgl))
     end
   end).()

```

---

_[View the full topic](https://forum.elixirforum.com/t/conditional-in-ecto-query/17541)._