PrimeObjects Developer Updateshttp://www.primeobjects.comIntelligent Business Knowledge Management, based on the Service Oriented Architecture (SOA) and Business Object Oriented Methodology, is the core of PrimeObjects’s platform. No matter it is dashboard, report, people, document, content, search, social communication, alert or activity, every feature in our solution is working around core business object. Our platform and solution are designed to solve real business issues, achieve accurate business intelligence and improve true business performance.<![CDATA[The 3 ways that HTML elements can be displayed]]>All HTML elements are naturally displayed in one of the following ways:

Block
Takes up the full width available, with a new line before and after (display:block;)
Inline
Takes up only as much width as it needs, and does not force new lines (display:inline;)
Not displayed
Some tags, like <meta /> and <style> are not visible (display:none;)

Block example

<p> tags and <div> tags are naturally displayed block-style.

(I say “naturally” because you can override the display style by setting the CSS display property e.g. display:inline;.)

A block-display element will span the full width of the space available to it, and so will start on a new line in the flow of HTML. The flow will continue on a new line after the block-display element.

Here I’ve started a paragraph and now I’m going to insert a <div>

new div inside my paragraph

and then continue the text here…

See how the <div> jumped in and took over the full width of the space?

Common HTML elements that are naturally block-display include:

<div>
Your general-purpose box
<h1> … <h6>
All headings
<p>
Paragraph
<ul>, <ol>, <dl>
Lists (unordered, ordered and definition)
<li>, <dt>, <dd>
List items, definition list terms, and definition list definitions
<table>
Tables
<blockquote>
Like an indented paragraph, meant for quoting passages of text
<pre>
Indicates a block of preformatted code
<form>
An input form

Inline example

Inline-display elements don’t break the flow. They just fit in with the flow of the document.

So here I’ve got a paragraph going on, and I’m going to add a <span> tag that has a yellow background and italic text. See how it just fits right in with the flow of the text?

More elements are naturally inline-style, including:

<span>
Your all-purpose inline element
<a>
Anchor, used for links (and also to mark specific targets on a page for direct linking)
<strong>
Used to make your content strong, displayed as bold in most browsers, replaces the narrower <b> (bold) tag
<em>
Adds emphasis, but less strong than <strong>. Usually displayed as italic text, and replaces the old <i> (italic) tag
<img />
Image
<br>
The line-break is an odd case, as it’s an inline element that forces a new line. However, as the text carries on on the next line, it’s not a block-level element.
<input>
Form input fields like and
<abbr>
Indicates an abbr. (hover to see how it works)
<acronym>
Working much like the abbreviation, but used for things like this TLA.

You change the display property of any elements

Although each HTML element has its natural display style, you can over-ride these in CSS.

This can be very useful when you want your page to look a particular way while using semantically-correct HTML.

Examples

Say you want to provide a list of items, but you don’t want a big bulleted list. You just want to say that you’re going to the store to buy:

  • some fizzy drinks,
  • a chainsaw,
  • and some nylon stockings.

Or maybe you want a nice toolbar, which is stricly a list (of links) and so should be marked up as a <ul>.

Here’s the code

<ul>
<li><a href=”#”>Home</a></li>
<li><a href=”#”>About us</a></li>
<li><a href=”#”>Products</a></li>
<li><a href=”#”>FAQs</a></li>
<li><a href=”#”>Contact us</a></li>

</ul>

Here’s how it looks as a normal list

Just adding the class “toolbar”…

<style type=”text/css”>
.toolbar li {
display:inline;
background-color:#eee;
border:1px solid;
border-color:#f3f3f3 #bbb #bbb #f3f3f3;
margin:0;
padding:.5em;
zoom: 1;

}

</style>

<ul class=”toolbar”>

<li><a href=”#”>Home</a></li>
<li><a href=”#”>About us</a></li>
<li><a href=”#”>Products</a></li>
<li><a href=”#”>FAQs</a></li>
<li><a href=”#”>Contact us</a></li>

</ul>

Here’s how it looks with the CSS styles applied

 

]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/f14ef6a8-5dd8-4ba7-880c-9c47764bfb67/The-3-ways-that-HTML-elements-can-be-displayed/default.blog.htmlf14ef6a8-5dd8-4ba7-880c-9c47764bfb67Mon, 12 Sep 2011 03:08:00 GMTGary Zhang<![CDATA[Fix: The function that will get web page title by a url as the parameter.]]>
title = System.Web.HttpContext.Current.Server.HtmlDecode(title);


]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/53717973-e963-44d4-85db-3bba3db134ba/Fix-The-function-that-will-get-web-page-title-by-a-url-as-the-parameter/default.blog.html53717973-e963-44d4-85db-3bba3db134baTue, 30 Aug 2011 16:49:29 GMTGary Zhang<![CDATA[How to configure browser compatibility]]>\\PrimeObjects.ApplicationSystem.Web\BrowserCompatibility.xml

Sample contents,
<BrowserCompatibility>
  <Browser Name="IE" Version="6" OldVersion="8"/>
  <Browser Name="Firefox" Version="3" OldVersion="3"/>
  <Browser Name="Chrome" Version="8" OldVersion="8"/>
  <Browser Name="Safari" Version="5" OldVersion="5"/>
</BrowserCompatibility>
]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/43d64a22-75e2-4d87-bad2-b3f1d503c046/How-to-configure-browser-compatibility/default.blog.html43d64a22-75e2-4d87-bad2-b3f1d503c046Mon, 27 Jun 2011 16:58:00 GMTKan Ma<![CDATA[Error when creating a linked server on SQL SERVER "Invalid authorization specification"]]>In SSMS, Server Objects -> Linked Servers, Right-click on SERVER2 and choose Properties.

In the properties window, click on "Security" in the left hand panel.

In the section labeled, "For a login not defined in the list above, connections will:", choose the last option "Be made using this security context:". Then specify a login and password for an account on Server2 with appropriate permissions for the task you're trying to accomplish.

]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/0370e8ee-0a30-478e-ae12-4f896ee6c08e/Error-when-creating-a-linked-server-on-SQL-SERVER-Invalid-authorization-specification/default.blog.html0370e8ee-0a30-478e-ae12-4f896ee6c08eThu, 23 Jun 2011 22:08:11 GMTGary Zhang<![CDATA[SQL SERVER Named Instance, Dynamic Port & Firewall]]>Dynamic Ports

By default, named instances (including SQL Server Express) use dynamic ports. That means that every time that the Database Engine starts, it identifies an available port and uses that port number. If the named instance is the only instance of the Database Engine installed, it will probably use TCP port 1433. If other instances of the Database Engine are installed, it will probably use a different TCP port. Because the port selected might change every time that the Database Engine is started, it is difficult to configure the firewall to enable access to the correct port number. Therefore, if a firewall is used, we recommend reconfiguring the Database Engine to use the same port number every time. This is called a fixed port or a static port. For more information, see Configuring a Fixed Port.

An alternative to configuring a named instance to listen on a fixed port is to create an exception in the firewall for a SQL Server program such as sqlservr.exe (for the Database Engine). This can be convenient, but the port number will not appear in the Local Port column of the Inbound Rules page when you are using the Windows Firewall with Advanced Security MMC snap-in. This can make it more difficult to audit which ports are open. Another consideration is that a service pack or cumulative update can change the path to the SQL Server executable which will invalidate the firewall rule.

The following procedure uses the Windows Firewall item in Control Panel. The Windows Firewall with Advanced Security MMC snap-in can configure a more complex rule. This includes configuring a service exception which can be useful for providing defense in depth. See Using the Windows Firewall with Advanced Security Snap-in below.

To add a program exception to the firewall using the Windows Firewall item in Control Panel.

  1. On the Exceptions tab of the Windows Firewall item in Control Panel, click Add a program.

  2. Browse to the location of the instance of SQL Server that you want to allow through the firewall, for example C:\Program Files\Microsoft SQL Server\MSSQL10_50.<instance_name>\MSSQL\Binn, select sqlservr.exe, and then click Open.

  3. Click OK.

]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/c390a976-8d0f-4e33-9954-998f71159db9/SQL-SERVER-Named-Instance-Dynamic-Port--Firewall/default.blog.htmlc390a976-8d0f-4e33-9954-998f71159db9Thu, 23 Jun 2011 22:06:28 GMTGary Zhang<![CDATA[Refresh include JS/CSS files]]> Normal 0 false false false EN-CA ZH-CN X-NONE MicrosoftInternetExplorer4

http://staging.rdhbe.com/default.aspx?flushincludefiles=true&theme=Lightness

http://staging.rdhbe.com/default.aspx?flushincludefiles=true&theme=Redmond

]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/5b5d706c-ad09-4d27-8767-793bbedf72f9/Refresh-include-JSCSS-files/default.blog.html5b5d706c-ad09-4d27-8767-793bbedf72f9Wed, 22 Jun 2011 16:47:22 GMTGary Zhang<![CDATA[SQL Stored Procedure - Create a new lookup attribute]]>EntityName_FK_AttributeName (i.e. Idx_Contact_FK_CompanyId).

Sometimes we need multi-lookup attribute, a multi-lookup attribute allows lookup more than one entity. For example, CustomerId on SalesOrder entity is a multi-lookup attribute, because it may contain a Contact or a Company as the value. To create a multi-lookup attribute, you can run the stored procedure multiple times with different LookupEntityId (i.e. the first run for Contact and the 2nd run for Company).

Although lookup attribute has only one corresponding physical column in the table, it will has four more columns in the database view.
  1. AttributeNameDisplay
    This will keep the display value of a lookup record.
    In the Contact(CompanyId) sample, it will be CompanyIdDisplay. Because Name of the Company is the "Display Attribute" of the Company entity, company name will be shown in this field in the Contact view (v_Contact).

  2. AttributeNameStateCode
    This will keep the statecode value of a lookup record.
    In the Contact(CompanyId) sample, it will be CompanyIdStateCode.

  3. AttributeNameEntityId
    This will keep the entityid of the lookup entity. For the single lookup attribute, the value in this field will be always same, but For the multi-lookup attribute, the value of this field can tell which entity the lookup attribute is looking for in a certain record.

  4. AttributeNameEntityName
    It works like AttributeNameEntityId.This will keep the entity name of the lookup entity.

Note: We highly recommend that the name of the lookup attribute contains "Id" as the suffix (i.e. CompanyId, CustomerId, PhotoId.) this will help us easily recognize a lookup attribute. 

DECLARE @EntityId uniqueidentifier
DECLARE @LookupEntityId uniqueidentifier
DECLARE @AttributeId uniqueidentifier

SELECT @EntityId = EntityId FROM Entity WHERE Name='Contact'
SELECT @LookupEntityId = EntityId FROM Entity WHERE Name='Company'

EXECUTE [p_PrimeObjects_CreateLookupAttribute]
   @SolutionId = NULL
  ,@SiteId = NULL
  ,@SystemUserId = NULL
  ,@AttributeName = 'CompanyId'
  ,@AttributeDisplayName = 'Company'
  ,@Description = 'Company'
  ,@EntityId = @EntityId
  ,@LookupEntityId = @LookupEntityId
  ,@AllowNull = 1
  ,@DefaultValue = NULL
  ,@CreateNavigationTreeViewItem = 1
  ,@IsSystem = 1
  ,@RegenerateEntityView = 1
  ,@AttributeId = @AttributeId OUTPUT
]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/710826a4-e020-44c5-854f-d8332b3414fc/SQL-Stored-Procedure---Create-a-new-lookup-attribute/default.blog.html710826a4-e020-44c5-854f-d8332b3414fcWed, 22 Jun 2011 16:47:22 GMTGary Zhang<![CDATA[SQL Stored Procedure - Create a new normal attribute]]>
@AttributeNameThe @AttributeName is the name of the attribute and also the name of the corresponding database column. The attribute name can only contain letter and number without space or other special chars.
@AttributeDisplayName The @AttributeDisplayName is the name that will be shown on the user interface.
@EntityId
The @EntityId tells which entity the attribute belongs to.
@TypeCode@TypeCode defines the type of the attribute. The following SQL Statement can be used to get a list of attribute types supported by the system.

SELECT Code,name,value DBType FROM PickList where AttributeUIId='8EE83AB5-ABA0-426A-962C-D02178738CC8' order by code
@AllowNull @AllowNull will tell whether the attribute allow NULL/Empty/NoValue.
@DefaultValue @DefaultValue will allow define the default value of the attribute. There will be a constraint created on the table for the default value defined here in the metadata.
@Formula
@IsVirtual
These two parameters are used to define a virtual attribute.
@ReferencedAttributeId
Please leave this parameter to be NULL, we will need it when we create some special attributes.
@ValueProviderAttributeId
Please leave this parameter to be NULL, we will need it when we create some special attributes.
@IsSystem
If @IsSystem=1, the attribute can not be deleted in the future.
@RegenerateEntityView
Every entity will have a corresponding database table with the same name and a database view with a v_ as the prefix in the name. For example, "Contact" entity will have a database table named "Contact" and a database view named "v_Contact". When an attribute is created, the database table will be updated by adding a new column, the database view can be updated as well by having @RegenerateEntityView=1 or leave the update to be done later by haveing @RegenerateEntityView=0.


DECLARE @RC int
DECLARE @AttributeId uniqueidentifier
DECLARE @EntityId    uniqueidentifier
DECLARE @ReferencedAttributeId uniqueidentifier
DECLARE @ValueProviderAttributeId uniqueidentifier

SELECT @EntityId = EntityId FROM Entity WHERE [Name] = 'Dashboard'
SELECT @ReferencedAttributeId = NULL
SELECT @ValueProviderAttributeId = NULL


EXECUTE @RC = [p_PrimeObjects_CreateNormalAttribute]
   @SolutionId = NULL
  ,@SiteId = NULL
  ,@SystemUserId = NULL
  ,@AttributeName = 'Javascript'
  ,@AttributeDisplayName = 'Javascript'
  ,@Description = 'Javascript'
  ,@EntityId = @EntityId
  ,@TypeCode = 12
  ,@AllowNull = 1
  ,@DefaultValue = NULL
  ,@IsVirtual = 0
  ,@Formula = NULL
  ,@ReferencedAttributeId = @ReferencedAttributeId
  ,@ValueProviderAttributeId = @ValueProviderAttributeId
  ,@IsSystem = 1
  ,@RegenerateEntityView = 1
  ,@AttributeId = @AttributeId OUTPUT
]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/4b6b3715-649f-4a89-bdf7-5c1b90588a4a/SQL-Stored-Procedure---Create-a-new-normal-attribute/default.blog.html4b6b3715-649f-4a89-bdf7-5c1b90588a4aTue, 21 Jun 2011 23:59:44 GMTGary Zhang<![CDATA[Sync definitions of a report from the local database to a remote database]]>The stored procedure below is helping you to create a new report or sync a existing report on a remote database server by using the report defined in the local database on which you are running this stored procedure.

EXEC [p_PrimeObjects_SyncRemoteReport]
    @SourceSolutionId  = NULL,
    @SourceSiteId = NULL,
    @SourceSystemUserId    = NULL,
    @TargetSolutionId = NULL,
    @TargetSiteId = NULL,
    @TargetSystemUserId    = NULL,
    @ReportId    =    'C581C284-A553-434D-9FCD-F86864175708',
    @TargetDatabaseName    = 'RemoteDBServer.RemoteDatabaseName'
]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/eff25292-1327-447d-a961-d42a2d33de20/Sync-definitions-of-a-report-from-the-local-database-to-a-remote-database/default.blog.htmleff25292-1327-447d-a961-d42a2d33de20Tue, 21 Jun 2011 20:50:38 GMTGary Zhang<![CDATA[@SolutionId, @SiteId, @SystemUserId Parameters in Stored Procedure]]>
EXEC p_PrimeObjects_GetContext @SolutionId = @SolutionId OUT, @SiteId = @SiteId OUT, @SystemUserId= @SystemUserId OUT
   
  • If the @SystemUser is null, the system will try to use the sql login user to map to a valid platform user.

    SELECT @SystemUserId = SystemUserId
    FROM SystemUser WITH (NOLOCK)
    WHERE DBLoginId = SUSER_SNAME()

  • If the @SiteId is null, the system will try to use the SiteId of the @SystemUser

    SELECT @SiteId = SiteId
    FROM SystemUser  WITH (NOLOCK)
    WHERE @SystemUserId = SystemUserId

  • If the @SolutionId is null, the system will try to use the SolutionId of the default solution

    SELECT @SolutionId = SolutionId
    FROM Solution  WITH (NOLOCK)
    WHERE IsDefault <> 0



]]>http://www.primeobjects.com/Blog/DeveloperUpdates/e9ee6c42-163b-4fde-a622-edc56aaea065/Article/326e97eb-e46b-49cc-aea6-2d66e2239cad/SolutionId-SiteId-SystemUserId-Parameters-in-Stored-Procedure/default.blog.html326e97eb-e46b-49cc-aea6-2d66e2239cadTue, 21 Jun 2011 19:35:45 GMTGary Zhang