How to create a database view?

Chandra18 · ‎11-11-2024

Hi,
I have two table "x_feedback" (Custom table) and "sc_request" table.
Table "x_feedback" have a field which name is 'task' it is a reference field and comes from table "task".
Can we put where clause with dot walking?
How can we make database view please help and provide way?

Chandra18 · ‎11-13-2024

Yes @AndersBGS But I achived the solution.

I have taken x_pgo as a parent table and put Where clause "hsf_task=afci_sys_id" (here variable prefix 'hsf' - x_pgo & 'afci' - sc_req_item) and another table I taken sc_req_item, so I am able to see request number and all Requested item table field.

View solution in original post

Dr Atul G- LNG · ‎11-11-2024

HI @Chandra18

Please have a look at ootb

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AndersBGS · ‎11-11-2024

Hi @Chandra18 ,

So if I understand you correct, both x_feedback and sc_request referencing the same sc_req_item? correct?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Chandra18 · ‎11-13-2024

Yes @AndersBGS But I achived the solution.

I have taken x_pgo as a parent table and put Where clause "hsf_task=afci_sys_id" (here variable prefix 'hsf' - x_pgo & 'afci' - sc_req_item) and another table I taken sc_req_item, so I am able to see request number and all Requested item table field.