Hello Developers,
Need your expertise in achieving this requirement.
I am trying to join Variables ownership (sc_item_option_mtom) table and Options(sc_item_option) table
Need this view for migrating RITMs variables as per requirement
I want the view to have parent item attribute from (sc_item_option_mtom) table and option, value attribute from (sc_item_option) table
Eg :
I am not able see records in view since not sure about where clause to join this table.
Requesting your assistance.
Thanks,
AbdulRahim
You almost had it. Try this:
With the Where clause on the second table
vo_sc_item_option=op_sys_idWhere clauses always follow the format prefix_field_name=prefix_field_name
That's going to be tricky. To aid in this, right-click the column headers and choose Configure > List Layout to add the Question.Reference and Question.List table (for List Collector variables) to the view. So now you can at least see the table the sys_id (or list of sys_ids) belongs to.
To see this all in the view, you will have to add a table for each unique reference table. All of these tables will be joined with op with Left join = true so that it shows all of the values whether they match that table or not.
Then you would add each Display column to the view so that you can see the display value (along with the sys_id...) but these will each be in their own column.
This will also cause the List Collector variables with only one record/sys_id to appear in the same display value columns. To get the List Collectors with a comma-separated list of sys_ids to appear and/or to replace the Value with the display value, you'd probably have to do something like export the view to Excel, then have an ODBC SQL connection that can run a GlideRecord query on the Reference table with the Value to return the Name (or Number, ...)
Sure. I'm not using a custom table in another instance, but this works for me to show the Database View on the RITM, so it should get you close. Create a Relationship (System Definition > Relationships in the left nav) using your Database View in the Queries from table.
Then right-click the RITM form header and Configure > Related Lists to select this new one.
Sure. I'm not using a custom table in another instance, but this works for me to show the Database View on the RITM, so it should get you close. Create a Relationship (System Definition > Relationships in the left nav) using your Database View in the Queries from table.
Then right-click the RITM form header and Configure > Related Lists to select this new one.
