I was trying to combine three tables and planning to build a database view

[Sathwik1]

I was trying to combine three tables and planning to build a database view, please check below and confirm what I did wrong?

When I click on trynow, getting below error.

@Ankur Bawiskar 

[Sathwik1]

@Its_Sagnic 

[Its_Sagnic]

Hi @Sathwik1 ,

To fix the error in your ServiceNow database view (u_kb_user_criteria_view), you must correct the syntax and logic of your Where clauses. Based on the screenshot and common ServiceNow configuration errors, you have two primary issues.

The Fix: Corrected Configuration

The error occurs because your Where clause uses underscores (e.g., uc_sys_id) instead of periods to reference fields, and the join logic for multiple tables needs to be chained correctly. 

Update your View Tables related list to match this configuration:

Table Order Variable prefix Where clause Left join

user_criteria	100	uc	(Leave Empty)	false
kb_uc_can_read_mtom	200	ucread	ucread.user_criteria = uc.sys_id	true
kb_uc_can_contribute_mtom	300	uccontribute	uccontribute.user_criteria = uc.sys_id	true

Please try the solution above if that is useful for you please markit as helpful and accept the solution to close the thread.

Regards,

Sagnic

[Chaitanya ILCR]

Hi @Sathwik1 ,

Try using the "   .  "  instead of the " _ " like (ucread.user_criteria=uc.sys_id)

did you add any view fields to the view tables?

if yes make sure the fields used in the where clause are included

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Sathwik1]

Now it's fine, but I don't see any data in the table.

Yes, I added views.. screenshot below.

@Chaitanya ILCR please help