#Custom tabview wikidot how to#
Most PeopleSoft customers will benefit from learning how to find component navigation. For example, WHERE REGEXP_LIKE (first_name, ‘^Ste(v|ph)en$’) returns Steven and Stephen. REGEXP_LIKE performs regular expression matching instead of the simple pattern matching. To return items with only one additional letter, use an underscore, such as FirstName LIKE ‘Laur_’).
For example, search WHERE(City LIKE ‘Lon%’) will return London and any other city that begins with Lon. When searching in PeopleSoft, use a % to replace any number of characters. The data can further be limited with a HAVING clause such as HAVING SUM(LineTotal) > 100000. SELECT SALESORDERID, SUM(LineTotal) AS SubTotal In the example, the data was re-ordered alphabetically by city.Īn aggregate such as SUM can be achieved with a similar approach to this example: You have the ability to set multiple filters of varying types.Īnother capability is Order By, which allows you to organize the data based on alphabetical or numerical qualification. In this case, the filter is City = London. The following is a simple select query, which selects three fields from the Employees table. The tables are interconnected by PeopleCode, PeopleSoft’s proprietary coding language. They vary from very basic and single-use to ghost tables in FMS to temporary tables to custom tables. HCM and Financials have thousands of tables. Why do we query? We query to understand the data beneath the pages that we see in PeopleSoft. Queries can be used for Ad hoc reporting, scheduling, search, population selection, and data sources for communications, BI reports, and pivot grids.
However, putting the two keys together keeps from duplicates.Ī basic query statement is Select, From, Where. Through SQL, logic tables are joined to make a single database.įor the key structure, you can have duplicates when there are multiple primary keys. Relational databases are created using a special computer language called Structured Query Language.
#Custom tabview wikidot series#
It contains a series of tables organized by key fields and unique IDs. The solution was to organize the data into a table with columns-representing a certain characteristic-and rows-representing each individual entry for that data element.Ī relational database in concept is structured to recognize relationships between items of information stored in the database. It was difficult to search for specific data or to create reports. Before databases were created, data was stored in flat files. It can be in several formats, including electronic, printed, graphic, audio, statistical, or a combination of two or more. PeopleSoft Query Manager Deep DiveĪ relational database provides an efficient way to store, retrieve, and analyze data. He also covered what you can do to ensure that your system keeps your information safe and secure while keeping your database from spinning out of control. Nori covered basic tips and tricks for query writing, creating smart prompts, and using expressions wisely. At RECONNECT, State of Minnesota’s Rahul Nori provided a Query Manager deep dive for both technical and functional users.
0 kommentar(er)
