Ashley, Try changing your second join clause to: JOIN asset a ON a.assetuid=dl.ownerid The OWNERID column is the sequenced numeric value assigned to each row in each table in the database. It can be found for each table in the Database Configuration application: Hope this helps, Alex
I have this query and get error below. How can I correct my query. Error converting data type varchar to bigint. QUERY SELECT a.assetnum,a.description,di.document,di.description,di.urlname FROM docinfo di JOIN doclinks dl ON dl.docinfoid=di.docinfoid JOIN asset a ON a.assetnum=dl.ownerid WHERE...
#Administration #Analytics #Architecture #Assets #Customizations #EndUser #EverythingMaximo #Infrastructure #Integrations #Inventory #IoT #LifeScience/Calibration #Linear #MaximoApplicationSuite #MaximoForAviation #MaximoUserGroups #Mobility #Nuclear ...
Screenshot 2024-02-07 092601.png
3815 Harrison AvenueCincinnati, OH 45211contact@moremaximo.com
Join CommunityInvite ColleaguesLearn MoreAbout UsTerms of Use