masking column with JAVA script, need help for write statement.

mohammada451459

20-04-2018

Hi Team,

I am trying to write below code to make the column XML column as blank but it is not happening , could anyone suggest where I am going wrong.

---------------------------Java code -------------------------

var query = xtk.queryDef.create(

<queryDef schema= {vars.targetSchema} operation="select" lineCount={vars.recCount}>

<select>

<node expr="[target/ctx]" alias="data" />

<node expr="@id" />

</select>

</queryDef>

)

var res = query.ExecuteQuery();

for each (var tmp in res)

{

logInfo("DATA Id : " + tmp.@id);

logInfo("DATA : " + tmp.target.data);

logInfo("-----------------");

var Data = "";

xtk.session.Write(<eventHisto xtkschema="nms:eventHisto" _operation="update" id={tmp.@id} tmp.target.ctx={Data}/>);

}

-------------------------------

Thanks

Arif

Replies

Highlighted

AbdulZa

23-04-2018

We do use both the cell-level encryption and the SHA256 when data is sent to the vendors (EM, MPUSH, DM, etc.).The requirement was for the system users not to have the ability to view PII columns however some of the PII data is needed for the vendors.