So I'm trying to make a webpage on perspective on ignition. This will be a full read and write gateway. The purpose is to keep track of the inventory of about a 1006 products. This means being able to search the number of the product and when you press search it tells you the exact location on the product in the building. I also want it to be interactable by the user so that if they take a product out and return it and store it at another location, they will have the ability to input the change manually. Can you roughly guide me as to how to approach this. I have a SQL database configured for it. I have the components on the screen as i want them just need to know how the script writing for each component goes ( not asking for the scripts)
You will most likely need some of these functions:
https://docs.inductiveautomation.com/display/DOC81/system.db
Using system.db.runNamedQuery you should be able to do everything you need. Having a named query for getting the data and then having one for changing the location of the product. You could even have the update named query log to a history tables as well if you want to keep track of previous locations.