Skip to Content
0
Former Member
Apr 17, 2014 at 09:34 AM

Convert sql result to .csv file

53 Views

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

Attachments

a.JPG (24.8 kB)
b.JPG (30.6 kB)