Skip to Main Content
Spotfire Ideas Portal
Status Will not implement
Product Spotfire
Created by Guest
Created on Jan 26, 2022

Spotfire Server Database - Set a value for all entries in the table LICENSE_FUNCTIONS

Having a field called 'LICENSE_FUNCTION_DISPLAY_NAME' with empty values does not help to get the accuracy required when it comes to creating reporting on Spotfire instances.


See attached screenshot.


Thank you for your consideration.


Kind regards,


Xavier

  • Attach files
  • Admin
    Miguel Díez
    Reply
    |
    Feb 25, 2022

    Hi Xavier,

    What's SpotfirePS (from the values in the screenshot)? Is it some customization that requires extra licenses? In that case it should have the display name with values. That should be easy to fix in the customization

    Some comments:

    • the database tables are not a public API. We cannot assure those names will remain the same on future versions.

    • you can fetch that info easier with show-licenses command

    Anyhow, in a working standard deployment all the values are non empty:

     SELECT *
    FROM LICENSE_FUNCTIONS order by LICENSE_FUNCTION_NAME;



    LICENSE_FUNCTION_ID LICENSE_NAME LICENSE_FUNCTION_NAME LICENSE_FUNCTION_DISPLAY_NAME
    ------------------------------------ --------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    7b1f43b7-a635-452e-8811-830595243d34 Spotfire.Dxp.Extensions access_to_extensions Access to Extensions
    6a0e9115-b056-4697-a97d-88cdb483a08d Spotfire.Dxp.Professional actionLink Action Links
    0128121a-07db-44a4-b8e3-ffc2c9533c40 Spotfire.Dxp.Administrator administrate Administration
    41a2cbce-b24a-4208-a7f0-00be2a6cd662 Spotfire.Dxp.Metrics advancedAggregationMethods Advanced Aggregation Methods
    9e8a1880-8921-42d6-852b-a3d3312cfd06 Spotfire.Dxp.Professional advancedDataProperties Advanced Data Properties
    97299777-8e1e-42b9-8a89-ca41cc13d6df Spotfire.Dxp.Professional advancedDocumentProperties Advanced Document Properties
    23bd674a-d5ca-400c-bc41-de5608b02747 Spotfire.Dxp.Professional advancedFilterPanelProperties Advanced Filter Panel Properties
    8e858814-2f4e-4947-8139-e6687be534d9 Spotfire.Dxp.Professional advancedVisualizationProperties Advanced Visualization Properties
    693443a9-fd5f-4758-ac10-8d62d5e6a486 Spotfire.Dxp.Connectors ApacheDrillConnector Apache Drill
    ecc49bcb-580b-41e6-a137-16905421b62f Spotfire.Dxp.Diagnostics applicationProfiler Application Profiler
    0b98bd48-a3a5-4c03-8aea-4e578a3087d8 Spotfire.Dxp.Extensions author_script Author Scripts
    088f81f4-6628-420c-92c1-c0d47e7c5dc8 Spotfire.Dxp.EnterprisePlayer bookmarkPanel Bookmarks
    73680fe5-7cc1-446c-8b43-101062b10fe3 Spotfire.Dxp.EnterprisePlayer bookmarksPrivate Capture Private Bookmarks
    84195b72-2f1b-4ba6-8f7c-f5284edb70a0 Spotfire.Dxp.EnterprisePlayer bookmarksPublic Capture Private and Public Bookmarks
    6cb95b04-18b2-4ec0-b61c-e4294f913118 Spotfire.Dxp.Professional changeColumnSelector Change Column Selector
    3a528578-c830-4cbd-ac7e-0478515ab71e Spotfire.Dxp.EnterprisePlayer changePassword Change Password
    a35004f2-f966-47df-ae78-0fea20065f30 Spotfire.Dxp.Connectors clouderaHiveClientConnector Cloudera Hive
    dc1e3e37-1960-4cae-990a-48040a937112 Spotfire.Dxp.EnterprisePlayer collaborationPanel Web Page Panel
    ...

    I think this is not product related. Can you confirm?

    Thanks