 |
Can I use
wildchar in query? |
| |
Yes you can.
"*" are supported.
|
|
Can I use comparison operator in query? |
| |
Yes you can. User can query using ">",
">=", "<", "<=", "!=",
"=".
|
|
How do I issue a query with OR logic? |
| |
"OR" and "AND" are
valid query symbol in the bizForm query. Please see the sample below
|
|
Can I use SQL function in a BizField? |
|
Yes, you can use SQL
functions provided by the database engine.
For example, <BizField Name="FullName" Column=""
SQLExpr="CONCAT([FirstName],' ',[LastName])"...>
|
|
Can I use
aggregate SQL result in a BizObj? |
| |
Besides
"SearchRule" and "SortRule", you can add any SQL
clause into "OtherSQLRule" in the BizObj element.
For example, <BizObj ... OtherSQLRule="GROUP BY [EvtId] HAVING
[SumFee]>10"...>
|
|
Is it possible to define the menu and
links to views? |
|
As Openbiz is a generic package, you can
build any UI based on it. The most useful client javascript function is
GoToView(...). Read more in manual 5.9
/*
function GoToView(view, rule, loadPageTarget)
- view is the BizView name
- rule is the search rule on a view.
- loadPageTarget is the target frame.
*/
|
|
Does openbiz provide authentication
functionality? |
|
Openbiz is a generic package, but
different customers might have different authentication requirements. So
openbiz only provides a simple authentication
functionality.
Go to bin/sysheader.inc, change define("CHECKUSER",
"Y"); define("TIMEOUT", 1200); Then the demo
application will check whether user has logged in or his session is timed
out. Since openbiz 2.0, user authentication is implemented in plugin
service.
|
|
How does openbiz provide access
control? |
|
Please read
the openbiz manual "Implement View and Data Access Control".
|
|
I need to build cross database
application, can I use more than one databases with openbiz? |
|
In the Config.xml, define several Databases as
Datasources, then assign the Datasource name as the DBName to BizObj. If
the DBName is empty, openbiz will use "Default" Datasource as
database connection.
|
|
Does Openbiz support report
functionality? |
|
PDF report and Excel output are supported
from version 1.1 as plug-in services. Also with proper template design,
you can create HTML reports too.
|
