How do I get second (or more) property from List Source on Grid?

Hi,

I am on MT Cloud environment.

When I am using Dropdown List filled by List Source, and when I am returning more Properties from the List source, I am using this code to get for example second Property from List Source:

But now, I have this type of Dropdown List on Grid.

So when I am processing row where user make change, I am triggered Data Change event, and using code like this:

But in row.Properties["marker"] there is no option for GetListValue function, when I need for example second Property from List Source.

What is correct approach here?

Thanks.

Find more posts tagged with

Accepted answers

All comments

unknown

Hi Pavel - I use Validators for this requirement. As well as validating the the selected value is in the list source, you can also use the "set prop/var/comp." to set the value of a property, variable or component to any value returned in the list source.

Pavel Matras

Hi Richard,

please can you give me some example, how to use Validators in this way?

I never use Validators in my app at all, and from Mongoose documentation, I am not sure how to do that.

Thanks.

SampleData.zip

VID015_SASTZ Lookup_How to Implement and Use.zip

BradleyBrown

You should be able to find a lot of information about validators here - docs.infor.com/.../default.html

unknown

From design Mode, click Edit > Validators
Click the + button bottom left
Give the new validator a name such as BCA_SYJG_Val
In the properties change the type to ‘In Collection’
In the Parameters select …
- Choose the IDO: BCA_SYJG_1
- In Set Prop/ Var /Comp click …
  - In Variables click …
    - Click New
    - The target for your first value should be %1
    - The Value is the field in your IDO you want to return i.e. description
    - Repeat for all the values you need
    - Click OK
  - I tend to copy the entry to components and properties to make it more generic
  - For property, select the value you are validating against, i.e. journalMarker.
  - You can enter the filter like you have done in the list source
  - Click OK
- For the error message use mIsNotAValid

To use the validator on a component

Select your validator. The first parameter will represent where the %1 value gets set. This can be a property variable or component. Below I have used a variable called varDescription - i.e. BCA_SYJG_Val(varDescription)

Set validate immediately to True (not sure why this isn’t the default)

I hope that helps

Pavel Matras

Many thanks for this help. I tried to setup this, but I must missing something.

For testing purposes, I am returning only one value here. So validator setup looks like this:

Then on grid column, setup looks like this:

So I want to fill value correspondingAccount into property accountCode on target form.

But property accountCode remains empty.

What am I missing here?

Pavel Matras

Hi,

sorry that I am returning to this old thread. But how can I setup this process when List Source is not Collection, but Global Script? Which takes data from ION API.

I am trying to switch Validator Type to "In List Cache", but I am not able to make it work.

Here is the error message. It seems that it is trying to found IDO PopulateBnkDropDown. But this is my Global Script, there is of course no such IDO present.

Thanks for any help.

Copyright © 2025 Infor. All rights reserved.