Filter multiple columns using sqlite.swift?

Question

let part = self.parts.filter(self.deleteStatus == 0).order(self.id.asc)

Above is the query I run to get all the records from local database. Now I want to add more filters like id==5 or name='product' in the filter. But the filter in sqlite.swift doesn't allow more than one expression in filter. How can I add more or filters in the filter method?

btraas · Accepted Answer · 2018-11-02 23:02:01Z

4

Filters can be chained with && (SQLite AND) and || (SQLite OR).

self.filter(deleteStatus == 0 && id == 5 && name == "product")

https://github.com/stephencelis/SQLite.swift/blob/master/Documentation/Index.md#filter-operators-and-functions

answered Nov 2, 2018 at 23:02

btraas

1483 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martheli · Accepted Answer · 2017-07-20 22:55:46Z

-2

The filter in Sqlite.swift does allow more than one expression; you just chain them together like this:

users.filter(id == 1 %% location == "Office" %% supervisor == "John")

answered Jul 20, 2017 at 22:55

Martheli

9812 gold badges18 silver badges38 bronze badges

Collectives™ on Stack Overflow

Filter multiple columns using sqlite.swift?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related