Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Limits to the SQL Statement when creating External Dictionaries

Limits to the SQL Statement when creating External Dictionaries

Does RC not provide the ability to concatenate multiple db columns into a single dictionary field?  When trying a query like:  SELECT Col1 + Col2 AS NewCol1 FROM Tbl1 we get an error("Unknown internal error") after clicking to save/create the new  dictionary.  This is on version 2008.3

Everyone's tags (1)
3 REPLIES
New Member

Limits to the SQL Statement when creating External Dictionaries

This is not supported in external dictionaries, as the dictionary corresponds to a table that needs to be updateable by newScale, and a computed column as shown in your example is not updateable.  (The error description, I admit, could be better.)

New Member

Limits to the SQL Statement when creating External Dictionaries

Thanks, I will then have to go with setting up an internal free form dictionary then use active form rules to populate the field with an onload database data retrieval.

New Member

Limits to the SQL Statement when creating External Dictionaries

What if you created a buffer table in your external database, that is populated by your field-merging query, and then invoke that from Newscale? The temporary table would be updatable by newscale (although, presumably, you wouldn't actually have newscale update it), so then it'd accept that connection.

For example, I think you could do something like that by creating a View in MS SQL Server. Likewise, in other database brands you could create a Trigger that would update the buffer table each time data in the real tables are changed.

166
Views
0
Helpful
3
Replies