- Happens when there are similar name and IDs with OBS.
- If two values in a dynamic query lookup start with the same first character in the name and the IDs are similar, when selecting the value in the New UX seems to default to the first value it finds alphabetically.
- The Clarity PPM New UX shows incorrect lookup value but the same lookup value shows correctly in classic view.
STEPS TO REPRODUCE:
1) XOG in simple OBS.
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_obs.xsd">
<Header action="write" externalSource="NIKU" objectType="obs" version="15.7.1.270"/>
<obsTypes>
<obs code="Test" isSecurity="false" name="Test">
<level depth="1" name="Test1"/>
<level depth="2" name="Test2"/>
<unit code="TestA" name="TestA">
<unit code="test23" name="ABCD"/>
<unit code="test2" name="ADBC"/>
</unit>
</obs>
</obsTypes>
<XOGOutput>
<Object type="obs"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="4" updatedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>
2) Create new Dynamic query lookup and paste the nsql:
SELECT
@SELECT:u.unique_name:
[email protected],
@SELECT:u.name:
[email protected],
@SELECT:u.last_updated_date:
[email protected]from prj_obs_units u, prj_obs_types t
where u.type_id = t.id
and u.depth = 2
and t.unique_name = 'Test'
and u.unique_name is NOT NULL
and @
[email protected]3) Create new attribute on Investment object with Data Type - Lookup - String and assign the dynamic query lookup from step 2.
4) In new UX add the attribute to project blueprints in the new ux Project Summary section.
5) Go to a project in the new ux and see if the values stick in the lookup field in the UI.
Expected behavior: Selecting either value for the attribute in New UX and the value should stick in the UI.
Actual behavior: Value always goes back to the first value it finds alphabetically.