SQL on View

[JulienMoulis]

Hi everyone,

I'm using a detail datapage on which I would like to show some average numbers. I'm using a view for this datapage. Is it possible to use SQL statement on views?

Here is my Statement:

SELECT SUM(FIDELIS_INTERVIEW)
FROM view_fidelis_emp
WHERE ID_EMP= [@authfield:ID_EMP]

 

Thanks

[oksigendigital]

hi Julien,

 

Try using this _v_name_of_current_view instead of 'view' after FROM.

[JulienMoulis]

hi,

view is the name my view.

But I did tried to use the _v_, but I received a weird error message such as  System error. (Caspio Bridge error) (FFFFFFFF)

I concated the support thks

[MayMusic]

try to rename your view to another name and then you need to use _v_ViewName to refer to it