I'm creating a database view to create a report to show only item ABC and its respective variables, but it's not bringing the data, I believe it's the where clause conditions, could someone help me!
I'm not sure I understand your requirements - why you need the sc_cat_item table. You can report on the sc_task table and see fields from the sc_req_item table via the parent or request_item field, and variables/values without a database view. If you want to continue with this approach, it should look more like this:
I'm not sure I understand your requirements - why you need the sc_cat_item table. You can report on the sc_task table and see fields from the sc_req_item table via the parent or request_item field, and variables/values without a database view. If you want to continue with this approach, it should look more like this:
