where clause in database view

[Deepthi13]

Hi team, I want to extract report on variable editor table with values. please suggest

i already created data base like below, but when i am filtering this in report it is throwing error as 2nd screen shot

[Bert_c1]

Hi Deepthi13,

Try using the actual column name 'sc_item_option' in the Where clause for the 2nd View table "optn_sys_id=mtom_sc_item_option". I don't see a column named 'sc_item_optn' on the 'sc_item_option_mtom' table.

[Deepthi13]

Hi Bert,

still i am facing same issue

[Deepthi13]

also i had one more doubt i cannot see data but can see count of the records could you please suggest

[Bert_c1]

Hi Deepthi13,

You can review Muhammand's response below.  What you see in the error message is a portion of the SQL generated by the platform to query a table in the database. Once your DB view is correct, you may want to create a Support Case to investigate.