Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
i have database of diffrent Equipments and their Technical Specifications.
Unfortunately the data Specification Entities are not equal by name eg
sometimes maker company Entered "manufacturer" and sometime "Manufactured By"
The DB structure sample is attached
Now the Problem:
I want to create a panel that user select an Equipment and the the spec value shown in text box.
Infact need a script that Return "SP_Value" that "SP_Description" Like "Manufact" for text box one and
Return "SP_Value" that "SP_Description" Like "Date" for textbox two and .....
Hi, the expression could be:
Manufacturer: =Only({<SP_DESCRIPTION={"*Manufact*"}>-<SP_DESCRIPTION={"*Date*"}>} SP_VALUE)
Date: =Only({<SP_DESCRIPTION={"*Date*"}>} SP_VALUE)
But I think it would be easier if you solve it in script, apply a mapping so it converts all differnt values to the same, also you can convert the date values to something that doesn't have the 'Manufact' word in it.
Hi, the expression could be:
Manufacturer: =Only({<SP_DESCRIPTION={"*Manufact*"}>-<SP_DESCRIPTION={"*Date*"}>} SP_VALUE)
Date: =Only({<SP_DESCRIPTION={"*Date*"}>} SP_VALUE)
But I think it would be easier if you solve it in script, apply a mapping so it converts all differnt values to the same, also you can convert the date values to something that doesn't have the 'Manufact' word in it.
Thats it.Very nice.Thank you