Issue in MULTIPLE FILTERS - WEB SERVICE

2»

Comments

  • Ravi_Thakkar
    Ravi_Thakkar Member Posts: 392
    Hello Derrick,

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

    Thanks once again.
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • derrick
    derrick Member Posts: 86
    Good to hear that! You're welcome.
  • Ravi_Thakkar
    Ravi_Thakkar Member Posts: 392
    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?
    Ravi_Thakkar
    Ahmedabad, Gujarat, India
    E Mail : ravi.thakkar@hotmail.com
  • RnR
    RnR Member Posts: 21
    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
    mihail_kolev Member Posts: 379
    open the page and check in which filtergroup are the filters (via About This Page). Then before the GETFILTER, call FILTERGROUP(<TheGroupYouNeed>);
    -Mihail- [MCTS]
  • RnR
    RnR Member Posts: 21
    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)

Categories