search

APEXGru / JET-PictoChart

Region Plugin to show a JET PictoChart based on a SQL statement
MIT License
2 stars 1 forks source link

Custom Shapes in to PictoChart #1

Open mahi2net opened 7 years ago

mahi2net commented 7 years ago

Hi RoelHartman,

Thanks for this useful plugin. I need to know that, Can we use Custom shapes in to this plugin ?

http://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=pictoChart&demo=customShapes#

APEXGru commented 7 years ago

Supported are these standard shapes: "circle", "diamond", "ellipse", "human", "none", "plus", "rectangle", "square", "star", "triangleDown", "triangleUp" (see http://www.oracle.com/webfolder/technetwork/jet/jsdocs/oj.ojPictoChart.html#items[].shape).

If you would change the Plugin a bit and add the "source" property to the "item" (pointing at an image) you can use the plugin with custom images.

According to the docs (but not quite sure whether that also applies to the JET version shipped with APEX): "shape" = The shape of the item. Can take the name of a built-in shape or the svg path commands for a custom shape. So it could be possible ...

mahi2net commented 7 years ago

Thanks Roel,

I noticed that all columns in to the query is passing to pictochart so just call another one column as "source" with svg path in to the sql query. But only one limitation, we couldn't control the color and other properties of shapes.

mahi2net commented 7 years ago

Hi Roel,

I found another one way also, Just pass path value of svg as "shape"

APEXGru commented 7 years ago

As you can see this plugin is very simple and very flexible, you can add / remove columns and that will have an effect on the generated JSON and thus on the end result.