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