query with blank parameter value

[Gregory Kohle]

Hi,

I tried using a parameter, which can be blank in a query.
There are only values displayed if I put in a value for the parameter.
Here is the query:

select distinct Partnum from Artikel
where PARTNUM like '%' + @SearchArticle + '%'

Do I have to do something else to get it working or should this work?
Thanks.

Regards,
Patrick

[Vijay Raja]

Hi Ptrick, 

Thanks for your interest in Syncfusion components. 

The provided query will return the data only for non-null inputs, you can use the OR SQL Logical operator to return data for null type values inputs as shown in the below query. 

SQL query: 

select distinct Partnum from Artikel where PARTNUM like '%' + @SearchArticle + '%' OR ( (@SearchArticle is NUll) AND (PARTNUM is NULL) ) 

Regards, 

Vijay R. 

[Gregory Kohle]

Hi Vijay,

I want to show all values when the parameter is blank and if there is a text then filter depending on that.
I noticed that if I enter some data and then make this field blank again then there is the outcome I wanted.
If i just leave the field ontouched then there is no data to be loaded.
I attached the report and a test database.
Thanks.

Regards,
Patrick

Attachment: ReportBlankSearch_38dcbf56.zip

[Vinoth Srinivasan]

Hi Patrick, 

 

The ReportParameter “SearchArticle” set to “Allow Blank Value”, so the empty sting value passed to the query and it fails in returning data. We request to enable the “Allow Null Value”, “Allow Blank Value” for the “SearchArticle” parameter to retrieve data at initial loading. We have modified your report based on this and it can be downloaded from the following location. 

 

https://www.syncfusion.com/downloads/support/forum/129967/ze/Artikel1302350198 

 

Regards, 

Vinoth S. 

[Gregory Kohle]

Hi Vinoth,

got it working now.
Thanks.

Regards,
Patrick

[Vinoth Srinivasan]

Hi Patrick, 

Thanks for your update. We are happy to hear that your query is resolved. Please let us know if you require any further assistance on this. 

Regards, 

Vinoth S.