Data Lookup Definition

snehalkhare · ‎09-13-2016

Hi

I want to set the assignment group based on category and subcategory for problem using data definition

Steps done by me

1.create custom table --Name : Problem Assignment Lookup ; extends table : [dl_matcher]

2.created the required fields i.e category,subcategory and assignment group

3.Data Lookup definition > New>Data Lookup Rule

Name:Problem Assignment Lookup

source : Problem

matcher : Problem Assignment Lookup(custom table)

4. have set the matcher and setter fields

Issue is that when I am opening the data lookup table to set the values , then the Choice list Values for these are not available .So I'm unable to enter the values.

How to solve this issue ?

Thanks

Snehal

Michael Fry1 · ‎09-13-2016

You do not need to create any fields. If you are referring to no drop downs in this field, I misunderstood:

You'll just need to edit the dictionary on each field like this:

However, if you're referring to unable to set drop downs on the Setter field definition, then my original post is the answer. You'll just need to modify the Setter form to add those fields to the form.

View solution in original post

Michael Fry1 · ‎09-13-2016

You'll need to add the Source table & Matcher table fields to the form. They don't come on the form out of the box, and once you add them, then you can select from the drop downs.

Michael Fry1 · ‎09-13-2016

Like this:

snehalkhare · ‎09-13-2016

Hi Michael

I have set the source table field and matcher table field both .Still not able to see the choice list values . Have attached the screenshots

Thanks

Snehal

Michael Fry1 · ‎09-13-2016

On the Setter Field definitions form, so where the drop downs show --None--, you'll need to add Match field & Source field. Review the screen shot I previously sent. The fields won't show on the form, but will allow you to set the drop downs.