V4MD API search in two fields of same table

[info at vallemediatime.com]

Hi Ruslan

in API is possible to search like this pseudo script?

rs = gTable.field(clickedCol).findValue(searchString) AND
gTable.field(otherCol).findValue(otherString)

or  I must use SQL query in this cases?

Thanks Paolo