what isthe difference between SQL View and Query View?
Answers were Sorted based on User's Feedback
Answer / krishna
In Sql view manually write the SQL statement, Query view
use the PS QUERY tool.
| Is This Answer Correct ? | 30 Yes | 7 No |
Answer / reddy
sql view and query view both are database objects,
sql view manually write the query, developer should know the
syntax. query view developed with ps query tool. just drag
drop the fields. no need to learn more about this tool
| Is This Answer Correct ? | 20 Yes | 3 No |
Answer / bharath
SQL View: We can manually write the SQL Statements
Query View: This is selected to define the record
definition as a view that is constructed using the
PeopleSoft Query tool.Before u can create the
view ,PeopleSoft Application Designer prompts you to save
the definition.
| Is This Answer Correct ? | 10 Yes | 6 No |
Answer / nagaraju
sql view and query both are database objects
sql view manually write the query and query view use the
psquery tool,and both are get the data from database
| Is This Answer Correct ? | 3 Yes | 1 No |
Explain what is user profile & security?
What is record group? Which records can be included into a record group?
What is portal (structure and content)?
What is application engine meta data?
Explain the use of set control field in record field properties?
What is field meta data?
What is security information?
What environments supported by people tools tool set?
How the output of a sql query be stored in a variable using peoplecode?
What is an array in people code?
Explain does peoplesoft support the web servers that bea weblogic and ibm websphere can plug into? How?
Write the syntax to access third level record field using object oriented peoplecode?