The
only difference between the standard view and dynamic view is that the dynamic
view is not defined as a view to the database—it is stored on the client and
run as a Select at runtime.
The
SQL used for dynamic views should be as simple as possible to avoid errors.We
can not use sub query inside a dynamic view. If query is too complicated we can
create a static view that the dynamic view references.
SELECT A.EMPLID
,A.EMPLNAME
,A.STAT_FTE1_CF
,A.STAT_FTE1_CM
,A.STAT_FTE1_FF
, STAT_FTE1_FM
FROM PS_USHR_M_HIS_VW A
WHERE A.MANAGER_ID = %OperatorId
