Hi,
I need help to get all my sql result in .csv file.
My scenario:
I select a privilege --> Choose UI task to generate user list per privilege as .csv file
my sql request is working fine but I cannot generate the .csv correctly. It's empty.
function users_per_priv(Par){
Var userMSKEY= Par.get("MSKEY");
var SQL="";
var SQL = "SELECT
L.mcOtherMSKEYVALUE Privilege,
U.mcDisplayName DisplayName,
FROM idmv_entry_simple U inner join idmv_link_ext2 L on U.mcMSKEY = L.mcThisMSKEY
WHERE L.mcThisOcName='MX_PERSON'
AND L.mcOtherOcName='MX_PRIVILEGE'
AND L.mcLinkState=0
AND L.mcOtherMSKEY=" + userMSKEY;
var result="";
result= uSelect(SQL);
result = uReplaceString(result, "!!", "|");
return result;
}
My problem is how to get the result in .csv in To Ascii File pass, and to manage the delimiter correctly?
Many thanks,
Mia