data base view is returning empty results but correct rows

[ms_akila]

created database view is returning empty rows..

cant use the sys_id field because this both table are user built type it dont have any reference fields, in these tables all fields are text field.

can anyone help on this?

[tanumoy]

I faced this issue once and a logout-login to the instance solved my issue. Could you please try that once.

[ms_akila]

Hi ,

I tried logout and login..still am facing the same issue

[ms_akila · Accepted solution]

Hi,

we should not use prefix character more than 3   for the database views, That is the reason , it returned empty rows.

Kindly use less than 3 characters in   prefix

[petercawdron]

That's really, really useful to know. You should mark your response as the accepted answer (or it can be a bit difficult for others to fine)