Customers are looking for changes in the FlexNet Operations On Premises List Entitlements page in both the End-User Portal and Producer Portal.
Some details may be hidden, such as changes in column settings or changes to the sequence of columns. Since the List Entitlements page configuration in the End-User Portal does not include everything from the Producer Portal, the queries described below can be helpful.
- Connect to the database which is configured with your FlexNet Operations On Premises instance.
- Run the queries listed below to check if matching data is present in tables.
- Update the query as per your requirements and run the updated query once it is finalized.
- After the update, check the changes in the End-User Portal to see if it looks correct. If it does not, then run the updated query again and reverse the changes.
select * from [dbo].[OPS_PORTAL_CONFIG] where FIELD_NAME like '%version' select * from [dbo].[OPS_PORTAL_CONFIG] where SCREEN_NAME like 'manageEntitlements.title' Select* from dbo.OPS_PORTAL_CONFIG where SCREEN_NAME='activatableItems.title' and FIELD_NAME='portal.manageEntitlements.TableColumn.Maintenance';select * from [dbo].[OPS_PORTAL_CONFIG] where SCREEN_NAME='manageEntitlements.title' and FIELD_NAME='portal.manageEntitlements.TableColumn.ProductVersion';update [dbo].[OPS_PORTAL_CONFIG] set DISPLAY_YN=0 where ID=8 and SCREEN_NAME='manageEntitlements.title' and FIELD_NAME='portal.manageEntitlements.TableColumn.ProductVersion'; - To update the List Entitlement page in the Producer Portal (to disable the Maintenance column), run the following query:
update dbo.OPS_PORTAL_CONFIG set DISPLAY_YN='0' where SCREEN_NAME='activatableItems.title' and FIELD_NAME='portal.manageEntitlements.TableColumn.Maintenance'; - To update the List Entitlement page in the End-User Portal (to disable the Maintenance column), run the following query:
update dbo.OPS_PORTAL_CONFIG set DISPLAY_YN='0' where SCREEN_NAME='manageEntitlements.title' and FIELD_NAME='portal.manageEntitlements.TableColumn.Maintenance';
After executing the above query for the List Entitlements page in the End User Portal, the Version and Maintenance columns will be hidden.
Related Articles
Supported Languages for FlexNet Operations End-User Portal Localization 8Number of Views Date Discrepancy with Entitlement Data Extracts using 'Data Import Template' option 4Number of Views Is there a merge tag for Maintenance End Date available? 3Number of Views How do I redirect the http://domain_name:port to Operations Portal Page Pather than WilFly page in FlexNet Operations 2017… 7Number of Views Can 'Data Import Template' be used to REPLACE the roles of users? 4Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago