 |
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. |
