Hello everyone, I am currently utilizing Datastream 7 for Asset management. A client has requested that I retrieve all work orders with tasks assigned to a specific company using the Dataspy feature. Upon trying to customize the Dataspy query, I discovered that the default SQL only selects information about the first task of the work orders. An example of a query that only selects the first task is: AND (a.act_act=(select min(b.act_act) from r5activities b where b.act_event=a.act_event) or a.act_act is null). Is it possible to modify the standard query for the work orders Dataspy? If so, how can I go about making this modification? I am aware that the Menu Query displays all configured queries, but I am unable to locate the specific one I am looking for. How can I find it? I then attempted to create a new Form assuming that a new Form would not have a default query. However, upon opening the new Form, I encountered an Internet Explorer error stating "Page not found", indicating a potential mistake in configuring the URL. The Administrator Manual provides an example URL format: http://app.server.com?USERID=:utente&PWD=:password but does not offer guidance on configuring the URL. Is creating another Form a viable solution to address my client's issue? If so, could you provide instructions on how to correctly configure the URL? Any assistance would be greatly appreciated.
Hello, it is possible to execute this query by writing some code on the Advanced tab of the dataspy tool. However, I would need more clarification on the tasks assigned to companies. If you need assistance, feel free to contact me, and I can guide you through the necessary tables and fields to query. Please specify the software version you are using - Forms or EWS, and whether it is Oracle or SQL Server. You can reach me at 804-337-6464. Thank you.
Hello Daniele, When it comes to analyzing data, creating a User Defined Grid is a more recommended approach compared to using a dataspy. A User Defined Grid can be customized to meet your specific needs and preferences. If you have any questions or would like to discuss further, please don't hesitate to reach out to me at ajith.shinde@bwir.com. Best Regards, Ajit Shinde Senior Consultant at BWIR Visit www.bwir.com for more information.
Hi there, it seems like you're dealing with a couple of different issues here. SQL subquery only retrieving information for the first task might be due to it employing the MIN function, which only returns the smallest value of the selected column. Try utilizing a different function or looping through the tasks related to each work order. As for locating the specific query in the Menu Query, my suggestion would be to break down your goal into more specific searches and filter out the unnecessary ones. Creating another Form could technically work but dealing with URL configuration errors can be tricky. The error you're experiencing with Internet Explorer may be related to site compatibility settings or security settings. A possible fix could be to add the website to your trusted sites and ensure that your compatibility view settings include how the website is displayed. Without knowing the specifics of your system, it's tough to give an exact solution, but I hope this gives you a good starting point! I'd also recommend reaching out to the Datastream customer support - they might be able to guide you appropriately or help you isolate the issue you're dealing with. Best of luck!
Hi there, I'd suggest you try using a left join in your SQL query to list out all the tasks for each work order, instead of only the first task. As for your issue with the new Form and its URL configuration, the 'Page not found' error usually occurs if the server name in your URL doesn't match with your actual server name, or if the name resolution isn't correctly configured in your network. Double-check your server name and ensure that you can ping it from the browser machine. Creating an entirely new Form should indeed be a viable solution if the URL is accurately configured. As you've already understood, working around Datastream's inherent limitations can sometimes be a bit challenging, but hopefully, this advice gives you a good starting point.
To address your first issue, you might need to write a custom SQL that doesn't limit the tasks to the first one for each work order. What you have seems like it is using a subquery to identify the first task (the one with the lowest act_act value) for each work order, so you may need to remove it or adjust it according to your requirements. As for the Dataspy, you should be able to copy and modify the original query, rather than having to locate it every time. First, use the Dataspy to create a new query, then copy your current query into it, making the necessary changes. Addressing your second issue, the Internet Explorer "Page not found" error might be due to a misconfiguration in the URL. It might be helpful to verify your server address and ensure it aligns with the format recommended in the Administrator Manual. Creating a new form could be a potential solution, but please double-check your URL format to prevent encountering the same error. If these suggestions don't work, consider reaching out to your software's tech support for further assistance.
It sounds like you're stuck in a tricky spot, but I might be able to offer a bit of assistance. To modify the default query, it's essentially gonna be about altering the SQL statement in your Dataspy. However, without seeing your unique system setup, it's tough to provide a definitive "one-size-fits-all" solution here. Nevertheless, if you wish to select all tasks instead of just the first one, you may need to remove the 'min' function in your query which only returns the smallest value (in this case, the first task). Regarding the inability to locate your query in the Menu Query, try to check the "all" box, maybe it's filtered out right now. As for the IE error, this issue is most likely due to an incorrectly configured URL. The structure of the URL should technically be correct as per your example, but the :utente and :password placeholders need to be replaced by your actual username and password credentials. In most cases, having ":utente" and ":password" in the URL means something went awry during configuration. Do review these parts and replace them with your actual login information, of course keeping the URL confidential. Remember that your company's IT department or an experienced colleague might also be a good resource for you to tap into. Sometimes, online forums may lack full context to give you the exact solution for your situation, as every system environment is unique. In-person, tailored support is often more beneficial when dealing with specific and technical issues.
Hi there! It sounds like you're in a bit of a tricky situation with the Dataspy query. To address the first part, modifying the default SQL to retrieve all tasks rather than just the first one is definitely achievable, but you may need to dive deeper into the query structure. As for locating the specific query in the Menu Query, check in the Dataspy configuration settings and look for custom or user-defined queries that might not be visible in the standard list. Regarding the new Form and the URL error, it's best to carefully follow the URL format in the Admin Manual, ensuring that you replace placeholders correctly and avoid any typos. Additionally, make sure that your server and app configurations are correctly set to accept your new form requests. If creating a new Form doesn't solve your problem, consider reaching out to your IT team for direct support. Good luck!
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: Answer: Yes, it is possible to modify the standard query for work orders in Datastream 7 to retrieve all tasks assigned to a specific company. You may need to adjust the SQL query to include information about all tasks associated with the work orders, rather than just the first task.
Answer: Answer: To locate the specific query you are looking for in Datastream 7's Menu Query, you can try searching for keywords related to work orders, tasks, or the specific company. Alternatively, you can contact Datastream 7 support for assistance in locating the query.
Answer: Answer: Creating a new Form in Datastream 7 can be a potential solution to address the issue of retrieving work orders with assigned tasks for a specific company. However, make sure to correctly configure the URL to avoid encountering Internet Explorer errors. Refer to the Administrator Manual for guidance on configuring the URL format correctly.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.