mohammada451459
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
richac96395021
richac96395021
20-04-2018
Hi Arif,
Can you specify the desired output and which XML Column are you trying to make it blank?
with regards,
Richa Chaubey
Jean-Serge_Biro
MVP
Jean-Serge_Biro
MVP
20-04-2018
Hi Arif,
I guess you duplicated your own post below, in order to the post to be put on top list?
I recommend to give up this post and go on the other one...
How can I mask CTX column in a schema (EVENT XML)
Regards
J-Serge
mohammada451459
mohammada451459
22-04-2018
Hi Richa,
The column is EVENT XML of schema eventHisto, I need to mask the column with blank value as GDPR ready process.
Thanks
Arif
mohammada451459
mohammada451459
22-04-2018
Hi Jean,
Yes you are right, but I would like to keep this one opened and I will close the other one. Hope that is fine with you.
Thanks
Arif
Jean-Serge_Biro
MVP
Jean-Serge_Biro
MVP
23-04-2018
Hi Arif,
Of course, you can do as you want. But I remind you that the right approach for GDPR considerations is using the accessibleIf attribute in schema (extended schema) rather Javascript code. Moreover it is more secure, easy to maintain.
Regards
J-Serge
mohammada451459
mohammada451459
23-04-2018
Hi Serge,
I agree and your solution looks quite easy to implement too, but since Business want's it that way so don't have much flexibility.
Thanks
Arif
Jean-Serge_Biro
MVP
Jean-Serge_Biro
MVP
23-04-2018
Hi Mohammad,
You should explain to your managers/business managers why it must be done differently
Otherwise, people without admin rights can get the data that you need to mask, a Javascript workaround isn't sufficient.
Regards
J-Serge
AbdulZa
AbdulZa
23-04-2018
Best practices to implement any data masking/hashing or encryption on the database level and not the application level while data is being pulled out the DB (possible cell-level encryption).
Jean-Serge_Biro
MVP
Jean-Serge_Biro
MVP
23-04-2018
Yes, I agree with you, best practice being on the DB level AND the nderlying framework level (such as recent SQL Server Enterprise edition or Oracle Enterprise edition allowed, but not supported by standard editions; or doing some hash function such as SHA256 or encryption).
However many Adobe Campaign customers have only access to the application level (console, or API), so using the schema AccessibleIf could be enough in many cases, while On Premise, or customers having access to direct DB storage engine (with ETL tool) have to manage GDPR concerns...