Hi Robert,
Sorry a little challenging to follow some of your logic but I am happy to try my best to help. Regarding building your table, I really would suggest that you take a look at this thread: Working With Data Table Widget
Your next question seemed to be how could you grab the parent sys_id from the URL. In your server or client side code you should try this method $sp.getParameter("sys_id"). From there you can most likely construct a query that would allow you to access the information that you are trying to seek.
Finally I see that you want want to use the data table widget by URL definition, in my experience I had success with using the Data Table from Instance Definition widget. I hope this helped, please let me know if there anymore information that you can provide and I will be happy to take a closer look.
Best Regards,
Philip Engles
Sorry for the difficulty with clarity.Maybe this will help?
1. Added the simple list widget linking to TableA on the homepage
2. Linked each item that displays in the simple list widget to the "ticket" page.
3. The opened page has the "Ticket Fields" widget which is calling items from the opened record (which is the parent)
4. The sys_id of the parent is listed in the URL as stated before.
5. I want to create a table underneath the "Ticket Fields" widget that shows all CHILD tasks that have the parent sys_id of the open record. So basically calling the sys_id of the opened record and using that as the parent sys_id for the child tasks. So it would look like this:
Let me know if that clears it up. In thinking about this, I'm wondering if I can somehow store the open record sys_id on the ticket table, and then call that from the table widget? Not sure if that is doable though. I think you and I are on the same page, I am just not sure how to fully create what I want. Appreciate the help!
Hi Robert,
Thank you for the expanding on your problem, I believe that it did help my understanding. I took a closer look at the Simple List widget and highlighted what stood out to me.
I am unsure which table that you are working on and how you are referencing your parent ticket but I would just use the above $sp method and string concatenation to construct your encoded query string. Then just pass your new encoded string variable inside of the highlighted text instead of the options.filter variable. Hopefully this solution works for you.
Best,
Philip E.
