Filter data source using 2 search fields

[tbar]

I'm trying to filter my gallery by 2 different items.

Here is the code: (the user can type into search text box to filter on any of the fields in qoutes)

SortByColumns(Search('[dbo].[Pharmacy]',TextSearchBox1.Text,"PharmacyName","BdcOwner","ConsultantOwner","City","State","ZIPCode","NPI","StreetAddress"),"PharmacyName",Descending)

BUT, I need to integrate a filter on the entire data set regardless of what they search for.

&& Search('dbo.Pharmacy',"0",SuppressInd)

This is to look at the SuppressInd column, which contains a 1 or 0, and only display those records that are not suppressed.

Right now, i get errors.

Can anyone find a way to integrate the 2?

Thank you!

[CarlosFigueira · Accepted solution]

The Search function returns a "table" with the records filtered by the condition you passed. You can nest multiple search calls in the same expression, searching on the result of another search call:

SortByColumns(
    Search(
        Search('dbo.Pharmacy',"0",SuppressInd),
        TextSearchBox1.Text,
        "PharmacyName",
        "BdcOwner",
        "ConsultantOwner",
        "City",
        "State",
        "ZIPCode",
        "NPI",
        "StreetAddress"),
    "PharmacyName",
    Descending)

 If the column "SuppressInd" contains only the values 0 or 1, you can also use a Filter expression:

SortByColumns(
    Search(
        Filter('dbo.Pharmacy', SuppressInd = "0"),
        TextSearchBox1.Text,
        "PharmacyName",
        "BdcOwner",
        "ConsultantOwner",
        "City",
        "State",
        "ZIPCode",
        "NPI",
        "StreetAddress"),
    "PharmacyName",
    Descending)