I dont know if ChatGPT is totally off or not on this but it has led me down a path telling me that I can use SavedQueries in Mxloader when I am using OSLC REST API calls. Can anyone confirm if this is indeed correct or not? If it is how do you accomplish as it wants me to add 3 settings in the Config Tab under the Advanced options:
ObjectStructure MXWOCUST
Operation query
savedQuery MY_MXLOADER_TEST
Then supposedly I leave the top row on my data tab blank (so I have no
| [OBJSTRUCTURE] |
[MAINOBJECT] |
Query |
but then populate columns I want back from my query.
Supposedly this will work.
I cannot get it to work to save my life and Google finds nothing about it.. This is what ChatGPT has said when I told it I think it is wrong:
No I cannot create it because it is not working. I think you are wrong
ChatGPT said:
I understand your frustration, and I apologize for any confusion caused earlier. Let's clarify the correct approach to using a saved query in MxLoader.
✅ Using a Saved Query in MxLoader
MxLoader supports the use of saved queries when performing a query operation. To utilize a saved query, follow these steps:
-
Config Tab: Ensure your Config tab includes the following entries:
| Name |
Value |
| Description |
Query Work Orders using savedQuery |
| MaximoURL |
https://maxtest.manage.mywebsite.com |
| User |
your-username |
| Password |
your-password |
| ObjectStructure |
MXWOCUST |
| Operation |
query |
| savedQuery |
MY_TEST_MXLOADER |
| UseAdminMode |
1 |
| OutputLog |
1 |
| AttachmentSupport |
0 |
Replace your-username and your-password with your actual Maximo credentials.
-
Data Sheet: Create a new sheet named MXWOCUST (matching the ObjectStructure) with the appropriate column headers corresponding to the fields returned by your saved query. For example:
Leave the data rows blank; MxLoader will populate them based on the query results.
-
Running the Query: After setting up the Config and MXWOCUST tabs, click the Run button in the MxLoader ribbon to execute the query. The results should populate the MXWOCUST sheet.
If you continue to experience issues or receive errors, please provide specific details about the error messages or behavior you're encountering. This information will help in diagnosing the problem more accurately.
Additionally, ensure that:
-
The saved query SNAVE_TEST_MXLOADER exists in your Maximo environment and is accessible to your user account.
-
The MXWOCUST object structure is correctly configured and supports the fields specified in your data sheet.
If you need further assistance or a sample MxLoader file configured with these settings, please let me know, and I can guide you through creating one.
------------------------------
David Miller
Managing Partner - Maximo Consultant
Enterprise Integration Partners LLC
------------------------------