Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How are manual primary keys configured for the SPS Content Administrator?

April 26, 2017Administrator configured content keys manual primary SPS

0

Posted

How are manual primary keys configured for the SPS Content Administrator?

1 Answer

0

Posted

Enter primary keys in the table configuration (for the SPS Content Administrator) as follows.

NAME=Companies … PRIMARY_KEY=stockSymbol DB_TABLE_NAME=Companies PRIMARY_KEY_GENERATE=MANUAL INDEX_SQL=SELECT stockSymbol, companyName FROM Companies ORDER BY stockSymbol NAME=stockSymbol PROMPT=Stock Symbol HELP=Stock symbol for this company (used to uniquely identify the company). …

Here we have specified that the primary key will be found in the field stockSymbol in the database table Copmanies. This field will be manually entered; thus, we have added a section to allow users to enter it. Note that the INDEX_SQL must select exactly two fields, the first of which must be the primary key. How are SPS-generated primary keys configured for the SPS Content Administrator? To configure an SPS-generated primary key, simply change the method to “SPS” and omit the description of the primary key from the set of s. For example, NAME=Contacts .

Can an administrator, professional development coordinator, literacy coach, ELA/content area director/supervisor, academic dean, etc. attend the academies?
How are SPS-generated primary keys configured for the SPS Content Administrator?
How are primary keys used in SPS?