Lookup field value not visible from front end

[Uruj]

Hi,

We are facing an issue in our application where we are selecting values in lookup field and saving; but it is not reflecting (we cant see) though changes are made in database.

Any help on the same will be appreciated.

Thanks,
Uruj

[navzjoshi00]

"We are facing an issue in our application where we are selecting values in lookup field and saving; but it is not reflecting (we cant see) though changes are made in database"

Have you taken SQL Trace to check what exactly is happenin' ?

NJ

[Uruj]

Hi NJ,

Thanks but I did not understand in what regard the sqltrace will help as the value is being updated in DB. It seems to be some other issue. Still, if you suggest sqltrace at what level should I go for?

Uruj

[navzjoshi00]

You can set it to normal 7, and see what activity is happening.

Besides, can you check the app-niku.log, as to whether there is any message when updating the lookup field ?

NJ

[Anon Anon]

Have you checked the 'last Update date' and 'last update by' column for the look up in DB?
Are they showing correct value?

[Uruj]

Yes they are showing correct values.

[Anon Anon]

Hi - I don't think that you are giving us much information to go on here in order to be able to help you... :unsure:

For example....

What type of lookup is it? (static/dependant/dynamic - if its dynamic this could be a coding error in the NSQL)

What exactly happens (OK you have said that there is no value when you select the lookup, but what happens when you return to that screen later? is the value there then?)

What Clarity version are you using?

What browser?

Is this always happening or just for specific users / specific APP services?

What about other similar lookups - do they all work?

Have you "flushed your caches"? (what happens then?)

Have you restarted your APP services? (what happens then?)

etc.

[Uruj]

Hi Dave,

1. Its a static lookup
2. The value was visible on selection but disappeared on saving and also not visible when returning to the page.
3. Clarity version: 12.0.6
4. Browser: IE and mozilla
5. This is not always happening; only for a particular lookup
6. Flushed caches; issue persisted.
67. Environment: Development

Though, due to user requirement we have removed the subpage and made a similar sub-object in this environment. The issue is not present in test or prod environments. I will update if such an issue is observed again.

Thanks all.


Regards,
Uruj

[vemsa02]

Hi,

I am facing the similar issue. Could you find any soultion?how can we resolve it.

Thanks,

Sandeep

[Anon Anon]

If you read the thread; then there are a number of suggestions about what you can do to investigate - so you should try these!  if you have done all that then you need to tell us what findings you have seen ; just saying "I have a similar problem" does not really help anyone to be able to help you!

(the original poster's problem went away because they changed their requirements)
 

[vemsa02]

Hi Dave,

Thank you for the quick reply!!

We are using v13.3 version of clarity, and browsers IE-10 & Firefox

Steps to reproduce the issue:

1) Create a static dependent lookup with 2 levels --> Lookup1

2) Add this lookup to a Custom attribute (Data type: Multivalued Lookup) on the project object (with Entry and Exit as Level1) --> Attribute 1

3) Create a parameterized dynamic lookup, which is referring to above Attribute. --> Lookup2

4) Add this dynamic lookup to a custom attribute (Data type: Multivalued Lookup) on the project object (with Lookup Parameter Mappings as Attribute 1) --> Attribute 2

5) Configure both attributes in project Edit layout.

Issue:

Once we select values in attribute 1, corresponding level 2 values will be present in the attribute 2. Till here it is fine.

Once I select the values in the attribute 2 and hit Save\Save and Return. The values in attribute 2 are no longer visible. But we can see these values on the Database level.

One more observation: When enabled audit trail on the attribute 2, the old and new values are showing blank.

Below is the dynamic lookup script used for attribute 2 (lookup 2)

SELECT  @SELECT:lookup_code:lookup_code@,
@select:name:name@              
from (SELECT lookup_code, name FROM    cmn_lookups_v
WHERE   language_code='en' and lookup_type='AD_ASSET'
AND is_active = 1
AND parent_lookup_code in (select lookup_code from cmn_lookups_v where
language_code='en' and lookup_type='AD_PLANT'
and lookup_code = (@WHERE:PARAM:USER_DEF:STRING:z_plnt_asset@))
)Where @FILTER@

 

Regards,

Sandeep.

 

[Anon Anon]

OK, either I don't understand what you are trying to explain here;

3) Create a parameterized dynamic lookup, which is referring to above Attribute. --> Lookup2

or you are trying to do something that I can't imagine would ever work?  (parameterised lookups driven from MVLookup attributes)

(screenshots might help explain?)

[Yadagiri Kastala]

Hi,

Check the Parent Window tab, and make sure Display Attribute is set correctly.

Regards
Giri

[Anon Anon]

uruj wrote:

Yes they are showing correct values.

Got it. However, i think its good if you verify all the points/questions mentioned by Dave in his post.
Let us know your findings.