Recommendation: Glide record on database view

[Kartik Choudha1]

Need a recommendation or suggestion.

I need to query a certain records by putting a filter two tables. I have a database view available on these two tables and i am able to query records from DB View with GlideRecord API.

Is it recommended to use glide record on DB view or not?

Is there any other way to achieve this?

Thanks in adv.

[J Siva]

Hi @Kartik Choudha1 

It's totally fine to use GlideRecord API on Database views.

There won't be any negative impacts.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0855795

Hope this helps.

Regards,

Siva

[priyatam_pvp]

If the data is small less than 10K records  → GlideRecord on DB View is fine 

For large data → Query each table separately & combine results 

Please mark it as helpful

Regards
Priyatam