Question

Adding Sql DB table to FSM smartclient

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

Userlevel 3

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

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

Userlevel 3

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.

Yes,I can query newly created table from FSM

Okay Perfect.Thank you so much

It really helped :)

Sign up