Skip to main content
Answer

Object reference Error Because of Null value passing in Dataview

  • March 2, 2023
  • 3 replies
  • 301 views

Forum|alt.badge.img+1

Hi,
I am getting Object reference error While Opening a screen.
The Issue Which I found was “Inside the Data View declaration Field Value is going null”;
Ex:
        public PXSelect<Table1,
          Where<Table1.Field1,
          Equal<Current<Table2.Field1>>,
            And<Table1.Field2,
                Equal<Current<Table2.Field2>>>
            >> DataView; 

In the Above Sample Query I am getting Table1.Field2 is Null value..Because of that Object reference issue is throwing while opening screen.

How can I solve this type of issue. Can any one suggest on this??

Thanks,
Giri.

Best answer by Giri K

Hi @Naveen Boga. We modified the Second where Condition inside View Delegate.

Thanks,
Giri.

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • March 11, 2023

Hi @girik06  I don’t see any issues with the VIEW but do you have any unbound fields in the table and not fetching the data on page loading and causing this issue?


Forum|alt.badge.img+1
  • Author
  • Pro I
  • Answer
  • March 13, 2023

Hi @Naveen Boga. We modified the Second where Condition inside View Delegate.

Thanks,
Giri.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • March 15, 2023

Yes, most of the cases we can see this issue when Table1 and Table2 is not tied properly. However, I'm glad that issue is cleared now.