findTask for concatenate search: is that possible?

[YvanBérard]

Hi all,

I would like to make a search for an address (i.e.: "45 wolfe") and retrieve some data where there is a match. But the trick is that the "45" is from the column [CIVIC_NUM] and the "wolfe" is from the column [ROAD_NAME].

Here is my table structure: [ID, CIVIC_NUM, ROAD_NAME, CITY, STATE].

Is there a way to do this?

For now, I'm only able to search separately for each element (such as "45" or "wolfe").

Thank you.

[danbecker]

Hi all,

I would like to make a search for an address (i.e.: "45 wolfe") and retrieve some data where there is a match. But the trick is that the "45" is from the column [CIVIC_NUM] and the "wolfe" is from the column [ROAD_NAME].

Here is my table structure: [ID, CIVIC_NUM, ROAD_NAME, CITY, STATE].

Is there a way to do this?

For now, I'm only able to search separately for each element (such as "45" or "wolfe").

Thank you.

specify the fields you want to search using:

findParams.searchFields = ["CIVIC_NUM", "ROAD_NAME"];