> For the complete documentation index, see [llms.txt](https://fivesobes.gitbook.io/nexorm/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://fivesobes.gitbook.io/nexorm/methods/finder-methods/usdsearchone.md).

# $searchOne

Filter and retrieve data from the table based on the provided conditions.

| Query          | Parameter's                                                                                                                     |
| -------------- | ------------------------------------------------------------------------------------------------------------------------------- |
| **`$where`**   | <mark style="color:yellow;">**`<StaticProps>`**</mark>                                                                          |
| **`$options`** | <mark style="color:blue;">⇒</mark> [<mark style="color:green;">**`<FindOptions>`**</mark>](broken://pages/09lM7s4YrcyDgm9Uz8Ri) |

*For example:*

```typescript
var filteredMember = await Member.$searchOne({
    $where: {
        username: {
            $eq: 'JohnDoe',
        },
        badges: {
            $in: [['Admin', 'Moderator']]
        }
    },
    $options: {
        $limit: 20,
        $offset: 10,
        $sort: {
            isPremium: -1
        },
        $cache: true
    }
});
```