Skip to main content
Question

Adding Sql DB table to FSM smartclient


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 20 replies

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

4 replies

Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 23 replies
  • May 3, 2023

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


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • 20 replies
  • May 3, 2023

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


Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 23 replies
  • May 3, 2023

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. 

 


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • 20 replies
  • May 3, 2023

Yes,I can query newly created table from FSM

Okay Perfect.Thank you so much

It really helped :)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings