WildCard Search in SQL Widget

WildCard Search in SQL Widget

  

Hi,

I have 2 questions here on how to do WildCard search in SQL widgets

1. How do i allow WildCard search on CompanyCode

a).if user key in the CompanyCode, the search will include the company code

b).If user does not key in the CompanyCode, the search will be for all Company

2.How do i allow WildCard Search on date where 

a).if user do not key in the date, the search criteria will be regardless the date

b).If user key  in the date, the search criteria will include the date. 


Help !!

Hi Johnson,

You do not want to use the SQL widget, but use an Aggregate instead. In an Aggregate, you apply a Filter, like 

MySearchValue = "" or MY_ENTITY.MyAttribute like "%" + MySearchValue + "%"

Note that in SQL, it will be about the same.