0
0 Comments

Discliamer: I do not know SharePoint enough

I need to create an External List per following requirements

  1. Users need to see & update metadata information about user databases via sharepoint.
  2. Users open a Sharepoint site and look for metadata
  3. Information Data being pulled from SQL server.
  4. Could be a workflow or list or whatever … I do not know

Sample finished product:

Select your Server

this comes from a SQL database

SELECT Servers from ServersTable;

Selecting a server will run another query based on what the user clicked

This is the last screen here users should be able to add additonal comments (Which means an Insert query for AllTables Table should be ran)

I tried creating an external list and pull Server names from a view that I created, but I do not know how to proceed forward, when I server list is displayed can I make it clickable and when clicked it runs a Stored procedure and display the results etc

Any ideas on whats the best approach for this ?

 

(Visited 17 times, 1 visits today)
Add a Comment