Database view with string match

[Devanshi Tiwar1]

Hi All,

I am trying to create a dbview where my requirement is to do a string match in where clause of a table. 

Like

metric_type = 'abcd'

Any suggestions on how this can be achieved?

Thanks in advance.

[Brad Bowman]

You can add this to a Where clause, along with the field that joins the tables, so for tables a and b it would look something like this:

a_sys_id=b_task&&b_metric_type='abcd'