how to create a report - looking for key words

[nico2]

Hello Everyone, 

Need help / ideas on the following: 

I have several custom tables I need to be able to run a report 

to see if the short description on

1. Custom table A and B have the keywords "R of R" or "R or R". 

2. Custom table C has the keywords "COVERAGE"

3. The data is within a start date and end date

if the above is met  output should be the claim #, Name, 

what is the best approach ? 

[vandna · Accepted solution]

Hi,

You can create an Database view on all three custom table, then you can create a report with all of the filter conditions.

Thanks.

[James Proske]

Look at this past community article for keyword conditions:  https://community.servicenow.com/community?id=community_question&sys_id=0991dcd7db5557407b337a9e0f9619dd

[nico2]

Thank you everyone for your help. 

It looks like database views is the way to go.