How to create a database view?

Chandra18
Mega Sage

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_0-1731335122438.png

 

1 ACCEPTED SOLUTION

Chandra18
Mega Sage

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

3 REPLIES 3

Dr Atul - LNG
Tera Patron

HI @Chandra18 

 

Please have a look at ootb

 

AGLearnNGrow_0-1731335408106.png

 

AndersBGS
Tera Patron

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

Chandra18
Mega Sage

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.