Parameters (placeholder) in Grid on c# code possible

Hello Coresuite Community,

I have a short question, is it possbile like in SAP SQL queries or Grid configurator queries to use paramters on grids genertated by c# code?

In this code example is the parameter a string varable.

 

// get OINS.internalSN
string strItemID = TextEdit.GetFromUID(pVal.Form, "44").Value;

Grid grid = Grid.GetFromUID(pVal.Form, "COR_GR1");

string query = @"SELECT
T0.[callID] AS 'Abruf-Nr.'
, T0.[createDate] AS 'Erstellungsdatum'
, T0.[subject] AS 'Thema'
, T0.[custmrName] 'Geschäftspartner'
, T1.[Name] AS 'Status'
, T0.[U_SWA_CT_SubCode] AS 'Equipment-ID'
FROM OSCL T0
INNER JOIN OSCS T1 ON T0.status = T1.statusID
WHERE T0.[U_SWA_CT_SubCode] = '" + strItemID + @"'
ORDER BY T0.[callID]";

// ATTACH QUERY TO GRID
grid.ExecuteQuery(query);

But can I use the placeholder syntax in coded queries to, like...

WHERE T0.[U_SWA_CT_SubCode] = '$[$44.0.0]'

When I use the placeholder syntax in those queries, I get no result, because it search for  '$[$44.0.0]' but not the value in the field.

Thanks in advance!

Sebastian

 

 

 

 

0

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post