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

[ramandeepgarg6]

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

[Coleton]

Are you using REST to fetch these INC records? If so and you're querying the INC table, you can add query filters to get the records you need.

[Deepak Ingale1 · Accepted solution]

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

[ramandeepgarg6]

Deepak is correct and it fixes the issue.

[Moy1]

you can create a custom table that is a child of the incident table and write a business rule that copies record from the incident to this new table that satisfies your condition.