41
Views
1
Comments
Filter Data In UI - When data in UI is feteched By Rest API with Odata
Question
Application Type
Reactive
Service Studio Version
1.0.9.1429

I have table below which showing on the UI (We are fetching data from rest endpoints and Odata)

IDStateIdStateName
11Maharashtra
22Bihar
33Gujarat
44J&K





And I have filters on above table like StateId, StateName and CityId which is we are not showing in above table.(that should filter out the data in above table) 
I have another table which having one to many relationships between StateId and CityId as given below   

CityIdStateIdCity
11Nagpur
21Pune
31Mumbai
42Patna
52Gaya
62Bhagalpur
73Rajkot
83Surat
93Bhuj
104Shrinagar
114Jammu
124Pulwama

My Question is how to filter the data by CityId (Input field) in UI table. Like If I input CityId 1 then only one record with Maharashtra as StateName will filtered out.


2021-12-07 07-28-47
Arnold Ayaoan Jr

Hi Rohan,

You can try the following:


Please see attached OML.

Hope this helps.

Regards,

Arnold

Demo_FilterCity.oml
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.