Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Fetch enum label instead of value from schema

tejashriw155148
Level 4
Level 4

Hi,

When I use querydef on deliveryStatus field from nms:broadLog schema, It returns values like 0,1,2,.. instead of label like Ignored, Sent, Failed.

Also tried below logic but its not working.

enumQuery.PNG

Please let me know how to fetch enum label from schema.

Regards,

Tejashri

1 Accepted Solution
Manoj_Kumar_
Correct answer by
Community Advisor
Community Advisor

Hello Tejashri,

The values in enumeration are numeric only. You can refer to the image below to get the exact status.

1858840_pastedImage_1.png

And in the java-script you can do something like this.

if(enumValue.@label=='1'){
var deliveryStatus='sent';
}

if(enumValue.@label=='2'){

var deliveryStatus='failed';

}

and so on.

Then you can use the deliveryStatus variable where ever you want to use to get the label.

Thanks

View solution in original post

7 Replies
Manoj_Kumar_
Correct answer by
Community Advisor
Community Advisor

Hello Tejashri,

The values in enumeration are numeric only. You can refer to the image below to get the exact status.

1858840_pastedImage_1.png

And in the java-script you can do something like this.

if(enumValue.@label=='1'){
var deliveryStatus='sent';
}

if(enumValue.@label=='2'){

var deliveryStatus='failed';

}

and so on.

Then you can use the deliveryStatus variable where ever you want to use to get the label.

Thanks

View solution in original post

tejashriw155148
Level 4
Level 4

Hi,

Could you please let me know where should I add above code to get enum value from deliveryLog.

Regards,

Tejashri

Manoj_Kumar_
Community Advisor
Community Advisor

Hello Tejashri,

This is how your updated code will look like.

for each(var enumValue in enumElt.enumValue){

        if(enumValue.@label=='1'){

               var deliveryStatus='sent';

        }

        if(enumValue.@label=='2'){

              var deliveryStatus='failed';

        }

}

Thanks,

Manoj

tejashriw155148
Level 4
Level 4

Hi,

I tried below code and getting result as:

Delivery Status is: undefined

enumLabel.PNG

Noticed that for loop is not working. Could you please check?

Thanks,

Tejashri

Manoj_Kumar_
Community Advisor
Community Advisor

Add this code on line no #3

var deliveryStatus="";

tejashriw155148
Level 4
Level 4

Hi,

Added var deliveryStatus=""; in code, but getting blank value.

yet For loop not working.

could you please give me other solution to display enum label?

Regards,

Tejashri

pierrec70731455
Level 5
Level 5

Hi,

Here is an alternative solution with analyze="true" and the variable @<my_enum_var>Label :

// vars.targetSchema = default variable generated by the previous Query activity in a workflow temp:queryExportDriveStatus

var schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":")+1);

logInfo(schemaName);

var xml =

  <queryDef schema={vars.targetSchema} operation="select" startLine={vars.count} lineCount={vars.batchSize}>

    <select>

      <node expr="@date"/>

      <node expr="@driveStatus" analyze="true"/>

      <node expr="@accountID"/>

      <node expr="@id"/>

    </select>

  </queryDef>;

var query = xtk.queryDef.create(xml);

var res = query.ExecuteQuery()[schemaName];//.queryExportDriveStatus;

var stati = '[';

for each(var status in res){

  stati += '{"account_id":' + status.@accountID + ',"drive_status":"' + status.@driveStatusLabel + '","status_date":"' + formatDate(status.@date, "%4Y%2M%2D") + '","drive_status_id":' + status.@id + ',"topicName":"prod_ingest_adobe_drive_status"},';

}

stati = stati.replace(/,\s*$/, "")+']';

logInfo("STATI : " + stati);