Records not visible in database views

[aditi__patil]

Hello Everyone,

I want to make a view of two tables namely : scan_targets and scan_results. I have combined them on basis of sys_id of the target field, where "combo.target" is the dot walk path. I am unable to view any records in the database view (although the fields are visible). Please help me troubleshoot this. Thank you!

[Ankur Bawiskar · Accepted solution]

@aditi__patil 

you cannot use dot walking in database view where clause.

You can try to join these 3 tables

scan_result, scan_target and scan_combo

If my response helped please mark it correct and close the thread so that it benefits future readers.

[aditi__patil · Accepted solution]

Hello Ankur, 

I tried the following and still am not able to view any records. Is there anything else I could do?

[Dr Atul G- LNG]

Hi @aditi__patil 

Seems you are doing wrong in where clause, here is example for OOTB

Check this and do the changes in where clause.

[aditi__patil]

Hello, I have also tried these kind of where clause but no data is shown in the view, is there anything else I could try?

[Ankur Bawiskar · Accepted solution]

@aditi__patil 

you cannot use dot walking in database view where clause.

You can try to join these 3 tables

scan_result, scan_target and scan_combo

If my response helped please mark it correct and close the thread so that it benefits future readers.

[aditi__patil · Accepted solution]

Hello Ankur, 

I tried the following and still am not able to view any records. Is there anything else I could do?