Issue in MULTIPLE FILTERS - WEB SERVICE

Ravi_Thakkar

Hello Derrick,

Thanks for your continuous help.
Your concept worked for me also. Thanks a lot.
=D> =D> =D>

Thanks once again.

derrick

Good to hear that! You're welcome.

Ravi_Thakkar

Hello All,

I want to filter the records having criteria related to one "Boolean" data type field.
e.g. List all customers having "Domestic (Boolean)" value to true.

How should i set the criteria?

RnR

I've created a custom table and a page from that.

Based on the filters set in the webservice call, I want to do some logic at the page.

But at the OnOpenPage this code returns "No filter" when the filter is set on MyField1:

IF GETFILTER("MyField1") = '' THEN
ERROR('No filter');

Is there no way to get the filters in the code at the page?

mihail_kolev

open the page and check in which filtergroup are the filters (via About This Page). Then before the GETFILTER, call FILTERGROUP(<TheGroupYouNeed>);

RnR

hmm, didn't work for me.

Seems like this is a well known issue: http://www.mibuso.com/forum/viewtopic.php?f=32&t=31193

When it comes to filters, this is how I did it in vb.net:

'Filter on OrgNo or customer name

Dim filters As New List(Of Customerws.Customer_Filter)
Dim filter As New Customerws.Customer_Filter

If txtOrgNo.Text.Length > 0 Then
   customerNumber = txtOrgNo.Text
   filter.Field = Customerws.Customer_Fields.Org_No
   filter.Criteria = customerNumber
Else IF txtName.Length > 0 THEN
   customerName = txtName.Text
   filter.Field = Customerws.Customer_Fields.Customer_Name
   filter.Criteria = customerName   
End If

filters.Add(filter)

DataGridView1.DataSource = client.ReadMultiple(filters.ToArray, Nothing, 100)