• Home
  • The Museum System
  • Business Intelligence
  • About Chad

Chad Petrovay

Tips and tricks for cultural heritage data management

Tag :status flags

SQL Scripting, The Museum System

Select Top 3 * From [Uses for Select]: Part 3

Chad Petrovay 24 May , 2016

So far, we’ve examined how to use the SELECT statement in SQL to create SQL Views for use in Crystal Reports, and as List Views in TMS. Now we are going to use the SELECT statement to create an alert in TMS.

Tweet
Share
Share
Pin
Continue Reading
SQL Scripting, The Museum System

Assign Status Flags using an Object Package

Chad Petrovay 12 May , 2009

Object Packages are a great way to collect together disparate artifact records, for whatever reason the package creator decides. By the same token, Status Flags are a great way to identify artifact records with special attributes, or that require special attention. A great time saver would be if you could mass assign a status flag …

Tweet
Share
Share
Pin
Continue Reading

Tags

advanced query Alternate Numbers backup solution batch assign bibliography Collective Imagination Constituents contact details Crystal Reports data profiling data quality data scrubbing data security data standards dbconfig digital images end-user support Events freebie Function key intangible objects library system list view Location Authority Locations Authority Media Objects Packages permissions Photosynth preaccession productivity querying Reluctant DBA remote access security group slide deck Social media SQL View statistics status flags text entries training virtual objects webinar

Categories

  • Business Intelligence (6)
  • Data Governance (4)
  • Database Administration (5)
  • Miscellanea (2)
  • SQL Scripting (17)
  • The Museum System (25)
  • xperience Gallery (2)
Chad Petrovay All rights reserved.
Powered by WordPress Theme by alfisahr