Question

Adding Sql DB table to FSM smartclient

+5

Hello Everyone,

I have created a new table in SQL DB to be able to use in FSM

I cannot find that table in FSM

Do i need to do anything to get that table visible in FSM

Thank you in advance

+8

from the custom metadata menu create an entry with the table name, and define each field. once done press load messages

+5

Hi ssabo

Thank you for your reply.

How to fetch the table data in FSM…if there is some data inserted into the table from sql db

Also how can i see the table in UI designer

Thanks again

+8

ensure first you can query the newly added table using the SQL Query tool, you may also need to refresh cache.

When creating a new screen in ui designer you are prompted with: Select the primary table to be your newly created one.

+5

Yes,I can query newly created table from FSM

Okay Perfect.Thank you so much

It really helped :)

Sign up