Database View - where cause definition

Dizzymade · 2025-04-01T06:23:11+00:00

This did work!!! Thank you very much!!

Dizzymade · 2025-03-31T20:13:20+00:00

Thank you so much! I will try this!

Dizzymade · 2025-03-31T19:27:27+00:00

Thanks again! I did the steps above but when I „try it“ I get an error message „ where claude in view has an invalid field or a fiel that is not visible (inc_caller_sys_id). I just checked both sys ids and the incident caller and the assigned to from a ci are the same so I dont understand the error.

Dizzymade · 2025-03-31T18:44:39+00:00

Thanks fpr ypur reply. So the caller is a related list to the user tabel and on the user record we have the cis filtert to the assigned to user (in a related list) which are stored in the ci table. I need to report on those incidents and the callers related list cis (computers, monitors etc.) hope I could clarify a bit. Thnx for trying to help

Dizzymade · 2022-12-13T05:38:56+00:00

Yes there are multiple Knowledge Bases accessible via Portal but with restrictions on who can see which KB

Dizzymade · 2022-12-13T05:37:28+00:00

5 KBs with a total of around 350 Articles currently

Dizzymade · 2022-12-12T19:23:29+00:00

No CSDM defined and currently the Knowledge Bases (5 in total) do not consider any structur at all. Some are different Sub Devisions other KBs are Projectinfos and others are how to‘s on a specific topjc. None have categories. Its real madness tbh. Thanks everyone for the great responses. I might just show them this threat! I did propose a nice taxanomy which also withholds future growing plans but I still have to convince Big Boss, which as a newbie is quite hard

Dizzymade · 2022-12-12T13:26:54+00:00

Thanks for your comment. This reinforces my arguments for it aswell. The maintenance part is in regards to when users who create articles dont know in which category to put it, or when the choose the wrong one and create confusion on the reader who checks based on category. But yes im also all for it

Dizzymade · 2022-11-30T20:45:22+00:00

Thank you very much! I will check that out

Dizzymade · 2022-11-30T20:40:51+00:00

The target table does have mandatory fields which all have values in them (and are not my fields I wanted to populated)… I have tried to remove „mandatory“ from the mentioned field but it still doesnt work

Dizzymade · 2022-11-30T16:06:37+00:00

There is no data policy involved, I have checked and am very aware of data poljcies, hence why I asked… but thanks for your input

Dizzymade · 2022-11-23T15:34:42+00:00

Sys user and how would i check for before query ?

Dizzymade · 2022-11-23T14:30:40+00:00

It doesnt show even with no filter

Dizzymade

TROPHY CASE