Creating database view for record producer variables

[Helen T]

I have created a database view that enables me to report on record producer variables using the question_answer and incident tables. That's working great, but I also need to be able to filter reports based on what record producer was used, so I was hoping to also add this to the view.

I've tried adding the producer via sc_item_produced_record, but I can't get it to return the producer name into the database view, it always shows up (empty).

Is someone able to point me in the right direction or am I trying to do something impossible? Do I need to add a field to the incident table to capture the record producer used?

Thank you in advance 🙂

[Rahul Kumar17]

Hi @Helen T .

To include the record producer name in your database view, you need to make sure that the producer name is being stored in a field that is accessible to your view. You can check the producer name in the sc_item_produced_record table and ensure that it is being stored in a field that is visible to your view.

If the producer name is not stored in a visible field, you could create a new field in the incident table to capture the record producer name. Then, you can use a Business Rule to populate this field with the producer name when an incident is created.

Once you have the producer name available in a visible field, you can join it to your existing view using the appropriate join criteria to filter reports based on the record producer used.

Keep in mind that if you are using multiple record producers for your record producer variables, you may need to add additional logic to your view to handle this.

Thanks,

Rahul Kumar