Database View on a single table and filter data to be displayed in database view

ramandeepgarg6 · ‎01-09-2019

Hi Experts,

3rd party has to fetch records from incident table and we don't want to expose whole incident table with all the records and columns. So idea is to expose database view of incident table with limited records and fields.

The issue is I am not able to filter the records in database view on a single table. Could you please help? "Where" query is not working.

Regards

Ramandeep

Deepak Ingale1 · ‎01-09-2019

Hello,

You need to have 2 tables for database view, once done, you can set filter as shown in screenshot below

Then run the view and you should see the desired results, please see below screenshot which shows only 1 record as per filter applied on number field above

Please mark reply as correct / helpful if it answers your question

View solution in original post

Deepak Ingale1 · ‎01-09-2019

Above database view is sufficient and addresses requirement without creating new extended child table. Any reason to create separate table?

Moy1 · ‎01-10-2019

I was just providing an alternate option