DataTable with parameter

Data Abstract
1

Hello,
I define DataTable like this:

SELECT MG.SIMBOL,
MG.DENUMIRE,
MG.TOTAL,
MG.NRDEPARTAMENT,
MG.STERS
FROM MARFA_GRUPA MG
WHERE
(MG.STERS = ‘F’)
AND (MG.SIMBOL IN (SELECT AG.SIMBOL
FROM AGENTI_GRUPE AG
WHERE AG.CODAGENT = :CODAGENT))

I’m using odata (or javascript client) for getting data.
If I set the proper parameter into url, everything is ok.
If I do not put any parameters then all the data come as the clause WHERE is completely missing.
This behavior is a bug or a feature?

How to make the WHERE clause I specified to be executed or 0 records returned?

Is it possible that parameter to be filled it directly from the session variable without the need to fill it in client?

Thanks,
Tiberiu Stoicescu

2

Hello. Unfortunately, I couldn’t reproduce this at first attempt. Could you check your schema, maybe this parameter has its default value set?
Doest ‘all the data’ means exact number of records that MARFA_GRUPA table contains?

3

parameter has its default value
Thanks