Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Valued Contributor
Posts: 93
Registered: ‎12-10-2003
Message 1 of 1 (99 Views)

Theming on Dates

99 Views, 0 Replies
10-25-2006 07:42 AM
Is it possible to theme layers based on date values? If so, how is this done?

I have a layer with a join to a SQL Server table and I cannot access datetime fields, nor SQL Server functions such as GETDATE() and DATEDIFF(). OK, it seems smalldatetime field types can be accessed, but I'm still not able to use GETDATE() etc. I don' t suppose there are any inbuilt functions in MG that will help? I've only seen one inbuilt function mentioned - the 'concat' function for string manipulation.

Perhaps the SQL Server functions need to be altered in some way in order to be passed on by MapGuide - e.g. the validate option in the Advanced expression builder in Studio complains about the value for units in the DATEDIFF function unless enclosed in single quotes. However, even when I can get the expression to validate, it doesn't have the expected effect in theming the layer (it appears to be ignored). Is there any guidance on building correctly formatted expressions?

Any ideas?

Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.