Hi everybody,
With Plex I want to make a "DISTINCT" in my view like in sql server. I was looking in the "CA PLEX HELP" and I Found this:
VW DBMS script SRC
So, I create a source code with this instruction:
-- END OF THE VIEW
#END
-- SELECT DISTINCT OF THE VIEW
#BEGIN
SELECT distinct * FROM [Nomina].[dbo].[AA1pV]
And Include this SRC in the triple of the view like in the picture below:
I compiled & Generated the view and the function which is pointing to that view.
The view retrieve all the data, and the 'distinct has not effect.
How could achieve to do a distinct in plex?
thanks.
P.D: This is the source code of my view that is generated using plex:
#BEGIN VIEW AA1pV
CREATE VIEW AA1pV AS
SELECT
T1.ReferenciaEntrada,
T1.EstadoTransaccion
FROM Aviso_Entrada T1
-- END OF THE VIEW
#END
-- SELECT DISTINCT OF THE VIEW
#BEGIN
SELECT distinct * FROM [Nomina].[dbo].[AA1pV]
#END