2 Replies Latest reply on Jan 30, 2018 9:37 AM by Giuseppe Baudo

    Dynamic argument in where clause

    Giuseppe Baudo Newbie

      Hi,

      I followed the tutorial of Jboss Data Virtualization installing the environment and trying the example.

      When I try http://localhost:8080/odata/federated_view/customerCreditInfo.CUSTOMER?$format=json  in my browser i get a json like this:

       

      {

      "d" : {

      "results" : [

      {

      "__metadata" : {

      "uri" : "http://localhost:8080/odata/federated_view/customerCreditInfo.CUSTOMER('CST01002')", "type" : "customerCreditInfo.CUSTOMER"

      }, "SSN" : "CST01002", "FIRSTNAME" : "Joseph", "LASTNAME" : "Smith", "ST_ADDRESS" : "1234 Main Street", "APT_NUMBER" : "Apartment 56", "CITY" : "New York", "STATE" : "New York", "ZIPCODE" : "10174", "PHONE" : "(646)555-1776", "creditlimit" : "21000.0", "creditscore" : "801"

      }, {

      "__metadata" : {

      "uri" : "http://localhost:8080/odata/federated_view/customerCreditInfo.CUSTOMER('CST01003')", "type" : "customerCreditInfo.CUSTOMER"

      }, "SSN" : "CST01003", "FIRSTNAME" : "Nicholas", "LASTNAME" : "Ferguson", "ST_ADDRESS" : "202 Palomino Drive", "APT_NUMBER" : null, "CITY" : "Pittsburgh", "STATE" : "Pennsylvania", "ZIPCODE" : "15071", "PHONE" : "(412)555-4327", "creditlimit" : "71800.0", "creditscore" : "767"

      }........

       

       

      Suppose i want to filter all customer that have CITY = 'NEW YORK'.  I reached the result adding AND (h2db_view.CUSTOMER.CITY = 'New York') with Criteria Builder and so deploying a new vdb file.

      My question is: Could i filter dynamically for CITY  without editing vdb file ? For example, is it possible to filter adding query parameter to query string in the url like this http://localhost:8080/odata/federated_view/customerCreditInfo.CUSTOMER?CITY='New York'&$format=json  ?

       

      Thanks,

      Giuseppe