Not able see data in User selection field from custom table in Support request catalog.
We have SMA-SM 2020.05 integration with SM9.60 version and we have created one support request catalog for End users.
In catalog , under User selection we have given one field named as productname and that field is pointed to one of the custom table and mapped the one of the field of that custom table to productname field.
But when we are trying to raise service request ticket from that catalog in service portal , in productname field data is not showing but that table is pointed to productname field have data into it.
We have checked the same catalog on SRC & ESS , there we can see the list of records in productname field but on SMA-SM service portal we cannot see the data.
So can you please help to resolve this issue.
For reference I have attached the snaps.
It could be an issue with the filter condition.
Can you share the screenshot of the User Selection filter definition?
It should look like below
Hello @Matilda ,
Same way , i have mentioned the filter condition and i can see all values in Preview of that catalog but not on portal.
Please find the attached screenshots for same.
I tried configuring this in our SMA-SM environment, there does seem to be some issue while fetching data from Custom tables.
You will need to log a Support case for this I suppose.
Let me know how it goes 🙂
I recently had this same issue. The root cause in our case was that there was not a qbe format in Service Manger for the table in question. Once we created a qbe format for the table, the data was returned properly.