saving dropdown

Question

if(
 ri!taskCode = cons!IC_TEXT_TASKCODE_RESERVE_NO_FOREWARD,
 {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!dropdownField(
 label: "Pull Zone",
 value: local!pullZoneValues,
 choiceLabels: local!pullZoneList,
 choiceValues: local!pullZoneList,
 placeholderLabel: "Select a Value",
 saveInto: {a!save(local!pullZoneValues,save!value),
 a!save(
 local!getLocnId,
 rule!IC_QRY_getLocnidFromMSTLocationHeader(local!pullZoneValues)
 ) }

 )
 }
 ),

 a!columnLayout(
 contents: {
 a!dropdownField(
 label: "Location ID",
 value:if(
 isnull(local!pullZone),
 null,
 index(ri!selectedTask,"locnId",null)
 ), 
 
 choiceLabels: union(local!getLocnId,local!getLocnId),
 choiceValues:union(local!getLocnId,local!getLocnId),
 disabled: isnull(local!pullZoneValues),
 placeholderLabel : "Select a Value",
 saveInto: a!save(
 ri!selectedTask.locnId,
 save!value
 )


 )
 }
 )
 }
 )

 },
 {}
), 
 /* rule!IC_QRY_getLocnidFromMSTLocationHeader */

a!queryEntity(
 entity: cons!IC_ENTITY_MST_LOCATION_HEADER,
 query: a!query(
 selection: a!querySelection(
 columns: {
 a!queryColumn(
 
 field: "locnId"
 )
 }
 ),
 logicalexpression: a!queryLogicalExpression(
 operator: "AND",
 filters: {
 
 a!queryFilter(
 field: "SKUId",
 operator: "is null"
 ),
 
 
 a!queryFilter(
 field: "pullZone",
 operator: "=",
 value: ri!pullZone
 )
 }
 ),
 pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: - 1,
 sort: {}
 )
 )
).data.locnId 
 the second dropdown field is not saving the values, whenever I select a value in dropdown it disappears. Any help would be appreciated.

Mike Schmitt · Accepted Answer

What is the data type of ri!selectedTask? If it's not type cast to a CDT, then you will probably need to change the "value" line back to how you originally had it (the commented out portion of the code I last posted).

Mike Schmitt · Answer

Replace the value parameter of the second dropdown with this and see what happens: 
 value: property(ri!selectedTask,"locnId",null), 
 In general what you have above is forcing the second dropdown to not show its value when local!pullZone is blank, however nothing from either dropdown that you've shown causes any value to be saved into local!pullzone . Maybe the if() statement should have been checking for the nullness of local!pullZoneValues instead, but I can't tell for sure based only on what you've provided.

Mike Schmitt · Answer

In your revised code I don't see any sign of you trying my original suggested change - i.e. you're still only showing a value in the "Location ID" column when local!pullZone is not null, but nowhere else in your posted code is saving a value into local!pullZone, so we would not expect the dropdown to show a value even if you try to set one.

Instead what I was asking for you to try should look more like this:

Mike Schmitt · Answer

That error isn't due to property - it would be the same if you switched back from "property" to "index" (they both work the same way); the reason you're seeing this error now is because, now that the if() statement is removed from the value (which was preventing the value from showing anything at all before), the dropdown is attempting to resolve the value "00009057" against the choice values, which as the error message states, does not contain that choice. 
 If you edit the value of ri!selectedTask and clear out the value of "locnId", the error will probably go away.

Mike Schmitt · Answer

I notice you've re-added the if() statement here for some reason -- so we're back to the original problem that your "isnull()" statement is checking the value of local!pullZone, which (at least in your earlier code example) never gets assigned a value. I think you may have meant to put local!pullZoneValues in that isnull(), because otherwise the second dropdown will never display any value.

Mike Schmitt · Answer

So that's a different issue altogether - to handle that, you need to add a new save into the saveInto of the first dropdown, to save a blank value into the value of the second dropdown anytime it's changed. This is a fairly standard requirement when developing cascading dropdowns where the selections in one depend on the value chosen in a previous one.

Mike Schmitt · Answer

Try this. BTW i think for the "value" of the second dropdown we can just directly access the ri property, as it likely won't have the issue of the property not existing (rule inputs are typecast to their CDT type, so the property will exist whether it's null or not). 
 if(
 ri!taskCode = cons!IC_TEXT_TASKCODE_RESERVE_NO_FOREWARD,
 {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!dropdownField(
 label: "Pull Zone",
 value: local!pullZoneValues,
 choiceLabels: local!pullZoneList,
 choiceValues: local!pullZoneList,
 placeholderLabel: "Select a Value",
 saveInto: {
 a!save(local!pullZoneValues, save!value),
 a!save(
 local!getLocnId,
 rule!IC_QRY_getLocnidFromMSTLocationHeader(local!pullZoneValues)
 ),
 a!save(
 ri!selectedTask.locnId,
 null()
 )
 }
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!dropdownField(
 label: "Location ID",
 value: /* property(ri!selectedTask, "locnId", null), */ ri!selectedTask.locnId,
 choiceLabels: union(local!getLocnId, local!getLocnId),
 choiceValues: union(local!getLocnId, local!getLocnId),
 disabled: isnull(local!pullZoneValues),
 placeholderLabel : "Select a Value",
 saveInto:a!save(
 ri!selectedTask.locnId,
 save!value
 )
 )
 }
 )
 }
 )
 },
 {}
) 
 (but, the important change I made is this: 
 
 )

saving dropdown

Top Replies