Clarity

I need to create a three drop down in clarity. which are:

Eg:
Country
State
District

State values will be populated based on Country
District dropdown is populated based on State.

Please help me to do this work. I am new to clarity.

Hi,

You need to create one lookup for each list , then add 3 attributes on the related object (Project or ressource) , connect each attribute with the related lookup , and show theses attributes on the right page of your object.

Then , for the lists to be connected, I suppose you may create one or more workflows which will react on the list change event (but not sure if it works).

Stéphane

Check the below -

2295436

32165996

NJ

Also -

2302369

NJ

Easiest solution to this is to use a SINGLE lookup which is a "static-dependant" type lookup. The lookup itself contains your "three levels" in a navigator-style ; i.e. you open up "country" and see a list of "states", you open up the state and see a list of "districts" from which you select one.

That is simple if you just need to display district, but what if you wanna display the other levels as well?

Martti K.

another_martink wrote:

That is simple if you just need to display district, but what if you wanna display the other levels as well?

TIP : How To Put Any Dynamically Generated Value On A Clarity Object ! cool)

--

Actually a simpler/better answer may be to just include the text for "levels 1 & 2" somehow in the description for "level 3"...

eg.

Level 1 : USA
Level 2 : Ohio
Level 3 : Sandusky (OH)

Level 1 : UK
Level 2 : Cheshire
Kevel 3 : Sale (UK, Cheshire)

?

As other responders have indicated you actually have a range of options:

1. Three separate attributes with static lookups (not such a great solution since there is no easy way of making your values inter-dependent)
2. A Static Dependent Lookup with three levels.
3. A single static lookup which contains all the available combinations of the three levels in a single list

and I will add
4. An OBS (which is going to be displayed along with the other OBSs on your object Edit view).

The best solution really depends on how you want to report the data - and this will depend on the details of how it is structured. Will every object instance always have a value defined at the lowest level of the tree for example? Is there just one value or do you want people to select more than one? Are they going to need to be able to filter for data at particular levels in the structure? Do we need to return the entire path of the selected value - or just the name of its lowest selected value? How many options are there altogether? Are you likely to want to add more options or levels later?

One problem with static dependent lookups is that the code necessary to deal with them in a portlet query can be rather complicated. Working with OBSs or static lookups is rather easier.

If your records contain Country State and District you would need only one field and single lookup which could be static.
While a Static Dependent lookup would have the dependency you would only see the lowest level and no automatic display of the other levels in other attributes without "How To Put Any Dynamically Generated Value On A Clarity Object !"
If you have three fields you could have three separate lookups and modify "How To Put Any Dynamically Generated Value On A Clarity Object !" so that there is automatic connection between them so that you would only select the lowest level item.

If you want do manual selection of all levels you could store the values in one or three custom objects.
The dynamic country lookup would use a select distinct to the country column,
the state dynamic lookup query would return "Select Country first" if the Country value is null and else Select distinct to the State column where Country = The previously selected value
the disctrict dynamic lookup query would return "Select State first" if the State value is null and else Select distinct to the District column where State = The previously selected value


Martti K.