Other Programming, Jquery, Peoplesoft
Drawing borders to city or state is simple and can be achieved using polygon overlays. As in mathematics, polygon is series of points connected by straight lines to form a closed region. In google maps, it is series of cordinates in an ordered sequence that form a closed group. The only part that is difficult […]
Here is simple query that lets you find the Menupath from given component Name. Just set the @PROJ_COMP and run the query to know the menu path where the component is registered.
If you have being using Peoplesoft, you will find that often there will situations where you would like to know the objects modified in the past week, month etc. There is a article in Peoplesoft WikiDot, which gives the list of objects modified after a certain date. The query provided was in oracle, I modified […]
In this article, we will see step by step procedure to attach a file and store it in the database. The article also shows how to view and delete the uploaded file. Assume that you have item table (PS_QNN_ITEM) with ITEM_ID as a key and basic item information such as Item Name, Description etc . […]
Views are a useful feature of SQL databases, letting us create virtual tables based on SQL select statements.
PeopleSoft 8 provides the functionality to create dynamic views. These are essentially SQL statements executed on the fly by the PeopleSoft component processor. We can use dynamic views in Peoplesoft pages only because they are Peopletools objects, not SQL Objects.
Using Dynamic as Prompt Table
In this article, we will see the use of Dynamic view as prompt table. Please note that dynamic view can be used for other purposes such as search records which will not discussed in the article.
One major question that pops up to many of us the first time we use dynamic view, why not use a normal view instead of dynamic view. A dynamic view’s select statement may include Peoplesoft’s meta-SQL, and it may be replaced by a different SQL statement while the user is using the page. And also there might be situations where which you do not save the view in the database.
Lookup latitude and longitude coordinates on Google Maps (Not API) To Lookup the geographic latitude and longitude coordinates of an address, you can follow the steps below 1 – Type in the address in google maps 2 – once you locate the address you want, just right click and select what’s here? in the menu […]
If you have never used google maps API before, I suggest you go through the article Create a basic map using Google Maps API to get acquainted with creating maps. In this article we create custom markers and attach custom message to the markers. Click on the link below to view the demo. Custom Markers […]
This tutorial is designed to show the first time user how to create a Google Map using the Google Maps API. The first step for using google maps is obtaining a API_KEY, developers can obtain a key here The key section in the above code is Once you obtain your API key replace YOUR_API_KEY with […]
Creating an alias for JQuery (other than the default $) The ready event handler also has a parameter that you can use instead of copying the global jQuery reference now jq is alias for JQuery unction Accessing div with two classes If you have divs with above class(es) and you want to select divs having […]
The article explains how to create simple portal with drag and drop portlets with JQuery/Jquery UI (with out use of any plugins) from scratch. The portal with have the ability to drag and drop portlets and also save the position and
state of the portlets.