- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-17-2016 12:27 PM
In service portal, I am using the ticket form and referencing TableA (the parent table in this scenario). When this page opens and displays the ticket information, I want to show a table as well that contains all child tasks from TableB with the parent# of the incident I have open on this page. The URL shows the SYS_ID of the parent item, so I'm assuming there may be a way to use table by url definition maybe? I'm not really sure.
Anyone have any insight on how I could accomplish this? Below is the sample URL:
Tagging a few people from previous posts as well. Hope you don't mind!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2016 12:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2016 11:34 AM
I understand dot walking. I get we are passing the variable now. The part I don't get, is how I get that variable into the filter of the 'data table by instance definition' widget. Pardon my ignorance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2016 12:14 PM
Are you just using the Data Table from URL Definition for ease of use? If yes I really would suggest again that you use the Data Table from Instance Definition widget instead. I linked a really good article on how to customize that widget in my first post. Having looked at the code for Data Table from URL Definition there appears to no great way to place the filter you are looking for; someone correct me if I am wrong. You would have to edit the Data Table widget and make a conditional checking for if the table name was 'task' then add the encoded query as we discussed. The reason I say it doesnt look easy to configure the URL Definition widget is due to (highlighted in yellow)
you might be able add another line under the orange arrow calling gr.addEncodedQuery(encodedQuery) and pass in the variable as previously mentioned. In my experience using Data Table from Instance Definition is the way to go; especially if this is just being used as a static table. If you have anymore questions I am happy to offer my two cents but I don't have as much experience using Data Table from URL Definition.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2016 12:22 PM
I changed to the Data Table from Instance Definition when you first responded to this post. Would it be easier to get this variable in this type of widget?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2016 12:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2016 12:42 PM
Got it working now using your last post! Thank you very much for your time and help on this. I greatly appreciate it!