pdf to tiff conversion c#: .Net read pdf text software application dll winforms html .net web forms SAP_HANA_Search_Developer_Guide

Getting a Paged Result List by Using the Parameter Offset

When calling the system procedure EXECUTE_SEARCH_RULE_SET, the application can return a paged result

list by using the parameters limit and offset.

● limit defines the number of rows returned

● offset defines the number of rows skipped

The following example returns a result list starting from row number 101 and ending with row number 110:

-- run the search

CALL EXECUTE_SEARCH_RULE_SET('

<column name="FIRSTNAME">billy</column>

<column name="LASTNAME">smith</column>

</query>

');

The parameter offset is only allowed together with the parameter limit.

Getting a User-Defined Result Set

When calling the system procedure EXECUTE_SEARCH_RULE_SET, the application can return a user-defined

result set instead of all columns defined in the attribute view.

-- run the search

CALL EXECUTE_SEARCH_RULE_SET('

<column name="FIRSTNAME">billy</column>

<column name="LASTNAME">smith</column>

</query>

');

In this case, the application returns a result set with the columns _SCORE, _RULE_ID, _RULE_NUMBER,

FIRSTNAME, and LASTNAME.

Using Custom Names for Predefined Columns

When calling the system procedure EXECUTE_SEARCH_RULE_SET, the application can return custom names

for internal columns _SCORE, _RULE_ID, _RULE_NUMBER.

-- run the search

CALL EXECUTE_SEARCH_RULE_SET('

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

PUBLIC

211

.Net read pdf text - C# PDF Annotate Library: Draw, edit PDF annotation, markups in C#.net, ASP.NET, MVC, Ajax, WPF

Draw, Add and Edit Various Annotations on PDF File in C# Programming

add crop marks to a pdf; adding text fields to a pdf

.Net read pdf text - VB.NET PDF Annotate Library: Draw, edit PDF annotation, markups in vb.net, ASP.NET, MVC, Ajax, WPF

Guide to Draw, Add and Edit Various Annotations on PDF File in VB.NET Programming

adding comments to pdf in reader; add text to pdf in preview

<column name="FIRSTNAME">billy</column>

<column name="LASTNAME">smith</column>

</query>

');

In this case the application returns a resultset with the columns _SCORE, _RULE_ID, _RULE_NUMBER,

FIRSTNAME and LASTNAME.

Adding Columns with a Constant Value to the Result Set

When calling the system procedure EXECUTE_SEARCH_RULE_SET, the application can return a result set with

additional columns, defined in the call of the procedure.

-- run the search

CALL EXECUTE_SEARCH_RULE_SET('

<column name="FIRSTNAME">billy</column>

<column name="LASTNAME">smith</column>

</query>

');

In this case, the application returns a result set with the columns _SCORE, _RULE_ID, all the view columns,

plus USER_NAME, and USER_ID. The last two columns have the values "Max" and "42", respectively, for all

result rows.

This feature is also available for the result table. The additional columns have to be created in the result table

with any SQL type. The columns have to be defined in the call to EXECUTE_SEARCH_RULE_SET as shown in the

example above.

Example

--First create the result table

set schema MY_SCHEMA;

CREATE COLUMN TABLE MY_RESULT_TABLE (

"_SCORE" FLOAT,

"_RULE_ID" VARCHAR(255),

"FIRSTNAME" TEXT,

"LASTNAME" TEXT,

"USER_NAME" NVARCHAR(100),

"USER_ID" INTEGER

};

-- Afterwards you can execute the search using the created result table.

CALL EXECUTE_SEARCH_RULE_SET('

<query>

<ruleset name="apps.customer:Search.searchruleset" /> -- specifies the

SearchRuleSet

<resulttableschema name="MY_SCHEMA"/> -- specifies the schema of the

result table

212

PUBLIC

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

VB.NET PDF Text Extract Library: extract text content from PDF

PDF ›› VB.NET PDF: Extract PDF Text. Advanced Visual Studio .NET PDF text extraction control, built in .NET framework 2.0 and compatible with Windows system.

add comments to pdf in reader; add text boxes to pdf document

C# PDF Text Extract Library: extract text content from PDF file in

C# PDF - Extract Text from PDF in C#.NET. Feel Free Best C#.NET PDF text extraction library and component for free download. XDoc.PDF

adding notes to a pdf; add editable text box to pdf

<resulttablename name="MY_RESULT_TABLE"/> -- specifies the name of the

result table

<column name="FIRSTNAME">Herbert</column> -- specifies the input value for

column FIRSTNAME

<column name="LASTNAME">Hofmann</column> -- specifies the input value for

column LASTNAME

</query>

');

-- get the result

select * from MY_RESULT_TABLE;

This feature is also available in conjunction with <resultsetcolumn>. You need to define the constant

columns as resultsetcolumns to specify the order. You also need to define the constant columns as shown

above to specify the constant values.

-- run the search

CALL EXECUTE_SEARCH_RULE_SET('

<column name="FIRSTNAME">billy</column>

<column name="LASTNAME">smith</column>

</query>

');

Limiting the Search to a Subset of the View Contents

-- run the search

CALL EXECUTE_SEARCH_RULE_SET('

<query>

<column name="FIRSTNAME">billy</column>

<column name="LASTNAME">smith</column>

<filter>"ORDER_DATE" BETWEEN '2012-09-01' AND '2012-12-31'</filter>

</query>

');

This filter limits the search to documents with an ORDER_DATE in the specified range. The filter condition is

evaluated in every rule, before evaluating the rule cut option and the query parameters limit and offset.

The filter condition must be a valid SQL WHERE clause with some extra rules:

● Comparative operators are allowed, for example: =, <, <=, >, >=

● Only a limited set of SQL keywords is allowed: NOT, AND, OR, BETWEEN, IN, LIKE, ESCAPE, IS, NULL,

UPPER, LOWER, SUBSTRING

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

PUBLIC

213

VB.NET PDF Image Extract Library: Select, copy, paste PDF images

Home ›› XDoc.PDF ›› VB.NET PDF: Extract PDF Image. VB.NET PDF - Extract Image from PDF Document in VB.NET. VB.NET: Extract All Images from PDF Document.

adding annotations to pdf; adding text to pdf document

VB.NET PDF: Basic SDK Concept of XDoc.PDF

And PDF file text processing like text writing, extracting, searching want to process images contained in PDF document, the following VB.NET classes will be

add comments to pdf reader; adding comments to pdf file

● The CONTAINS() function is not allowed, since this would affect the score() that is returned

● Only columns defined in the attribute view are allowed

● All column identifiers must be enclosed in double quotes (")

● All string values must be enclosed in a pair of two single quotes (")

<filter>"CITY_NAME" = ''Walldorf''</filter>

Searching Views with a Client Column

The filter condition described above can be used to search views that have been created by SAP business

applications. Usually these applications define tables and views with a client column. This column is, for

example, called MNDT, CLNT, or CLIENT. Limit search results to rows belonging to the same client as the

current user. This can be done by adding an appropriate filter condition to the call to

EXECUTE_SEARCH_RULE_SET, as shown in the following example.

-- run the search

CALL EXECUTE_SEARCH_RULE_SET('

<query>

<column name="FIRSTNAME">billy</column>

<column name="LASTNAME">smith</column>

</query>

');

4.3.4.12.8 Tutorial: Create and Use Search Rules

This tutorial documentation describes the development of an application that uses the search rule sets to

search on a table containing a company's customers.

Prerequisites

As a developer who wants to create search rule sets, you are familar with the SAP HANA development

environment.

The development tools for search rule sets are part of the development environment for native SAP HANA

applications. Nevertheless, search rule sets can be used in all types of SAP HANA applications.

The Scenario

This tutorial documentation describes the development of an application that uses the search rule sets to

search on a table containing a company's customers. The data model used for this tutorial is very simple. Let

us assume that all customers are people, so no company information can be stored in the table.

214

PUBLIC

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

How to C#: Basic SDK Concept of XDoc.PDF for .NET

And PDF file text processing like text writing, extracting, searching want to process images contained in PDF document, the following C#.NET classes will be

add comments pdf document; adding a text field to a pdf

C# PDF - Read Barcode on PDF in C#.NET

Page: Delete PDF pages; VB.NET Read: PDF Text Extract; VB.NET Read: PDF Image Extract; VB.NET Write: Insert text into PDF; VB.NET Write

add text field pdf; add text pdf

Users and Roles

When building an application based on SAP HANA, different database users are created for modeling content

and for running the application. Privileges have to be granted to give each user a minimum set of access rights

needed to perform tasks corresponding to his or her role.

The scenario in this documentation uses the following database users:

● The data stored in the column tables is owned by the first user called TABLEOWNER.

● Attribute views and search rules are modeled by a second user called MODELOWNER.

● Finally, the application runs with a third user called APPOWNER.

Instead of granting privileges to users directly, you can use roles.

4.3.4.12.8.1 Creating the Application Package

Context

In our example, the database content (the attribute view and the search rule set) will be stored in a package

called "apps.customer".

Procedure

In the SAP HANA studio, create a new package named customer.

You can create the package in the SAP HANA Systems view of the SAP HANA studio (either in the Modeler

perspective or in the SAP HANA Development perspective).

Use the SYSTEM user or any other user with sufficient privileges.

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

PUBLIC

215

C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net

Different from other C# .NET PDF to text conversion controls, RasterEdge C# PDF to text converter control toolkit can convert PDF document to text file with

add text field to pdf; adding text to a pdf form

C# PDF Image Extract Library: Select, copy, paste PDF images in C#

and online C# class source code. A powerful C#.NET PDF control compatible with windows operating system and built on .NET framework.

add comments to pdf online; add text pdf acrobat

4.3.4.12.8.2 Creating the Users

You have to create three users and and assign a set of privileges to them. The users are created by the

administration user SYSTEM or by any other user with sufficient privileges.

Procedure

1. Create the TABLEOWNER

CREATE USER tableowner PASSWORD "********";

-- privilege needed to create the application schema

GRANT CREATE SCHEMA TO tableowner;

2. Create the MODELOWNER

CREATE USER modelowner PASSWORD "********";

-- Allow repository access from SAP HANA studio

GRANT EXECUTE ON _sys_repo.repository_rest TO modelowner;

-- Privileges needed to access packages in the HANA repository

-- read access to packages and designtime objects (native and imported

objects)

GRANT REPO.READ ON "apps.customer" TO modelowner;

-- all kinds of inactive changes to design-time objects in native packages

GRANT REPO.EDIT_NATIVE_OBJECTS ON "apps.customer" TO modelowner;

-- activate / reactivate design-time objects in native packages

GRANT REPO.ACTIVATE_NATIVE_OBJECTS ON "apps.customer" TO modelowner;

-- create, update or delete native packages, or create subpackages of native

packages

GRANT REPO.MAINTAIN_NATIVE_PACKAGES ON "apps.customer" TO modelowner;

-- permission go grant and revoke privileges on activated content (like, for

example, attribute views)

216

PUBLIC

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

VB.NET PDF Convert to Text SDK: Convert PDF to txt files in vb.net

Using this VB.NET PDF text conversion API, users will be able to convert a PDF file or a certain page to text and easily save it as new txt file.

add text box in pdf document; add comments to pdf document

C# PDF Text Search Library: search text inside PDF file in C#.net

C#.NET PDF DLLs for Finding Text in PDF Document. Add necessary references: C#.NET PDF Demo Code: Search Text From PDF File in C#.NET.

adding stamps to pdf files; add text to pdf without acrobat

GRANT EXECUTE ON GRANT_PRIVILEGE_ON_ACTIVATED_CONTENT TO modelowner;

GRANT EXECUTE ON REVOKE_PRIVILEGE_ON_ACTIVATED_CONTENT TO modelowner;

-- A user needs an analytical privilege to access activated attribute views.

-- The predefined privilege _SYS_BI_CP_ALL gives access to all activated

content.

-- Create your own analytical privilege if a limited access to activated

content is needed.

CALL _SYS_REPO.GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE('_SYS_BI_CP_ALL',

'MODELOWNER');

-- privileges needed to run the search rules

GRANT EXECUTE ON sys.execute_search_rule_set TO modelowner;

Note

_SYS_RT.SEARCH_RULE_SETS Table

The _SYS_RT.SEARCH_RULE_SETS must not be queried in applications using search rule sets.

If you do not want to assign a large number of privileges to each modeling user, you can create a new role

containing all required privileges and assign this role to the users. This is the preferred option, but

alternatively you can also use the predefined MODELING or CONTENT_ADMIN roles to grant the

privileges.

3. Create the APPOWNER

CREATE USER appowner PASSWORD "********";

-- A user needs an analytical privilege to access activated attribute views.

CALL _SYS_REPO.GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE('_SYS_BI_CP_ALL',

'APPOWNER');

-- privileges needed to run the search rules

GRANT EXECUTE ON sys.execute_search_rule_set TO appowner;

Note

_SYS_RT.SEARCH_RULE_SETS Table

The _SYS_RT.SEARCH_RULE_SETS must not be queried in applications using search rule sets.

4.3.4.12.8.3 Creating the Database Schema and Tables

Context

You have to create a new database schema called 'CUSTOMERS' to store the database tables.

Then, you create the table 'CUSTOMER' in the new schema to store information about customers such as

name, address, phone number, and date of birth. The example uses a simple table definition only, but more

complex table definitions including 1:n relationships between names and addresses are possible.

The schema and table are created by the user TABLEOWNER.

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

PUBLIC

217

Procedure

Creating the Database Schema and Tables

CREATE SCHEMA customers;

SET SCHEMA customers;

-- create sample table

CREATE COLUMN TABLE customer

(

id INTEGER PRIMARY KEY,

firstname SHORTTEXT(100) FUZZY SEARCH INDEX ON,

lastname SHORTTEXT(100) FUZZY SEARCH INDEX ON,

streetname NVARCHAR(100) FUZZY SEARCH INDEX ON,

housenumber NVARCHAR(20) FUZZY SEARCH MODE

'housenumber',

postcode NVARCHAR(20) FUZZY SEARCH INDEX ON FUZZY SEARCH MODE

'postcode',

cityname NVARCHAR(100) FUZZY SEARCH INDEX ON,

countrycode NVARCHAR(2),

phone NVARCHAR(20),

dateofbirth DATE

);

-- needed to model an attribute view on top of the table

GRANT SELECT ON customer TO modelowner;

-- needed to allow activation of attribute views that use this table

GRANT SELECT ON customer TO _sys_repo WITH GRANT OPTION;

-- for better performance, database indexes should be created

-- on all NVARCHAR columns that are used in the search rules

-- example:

CREATE INDEX customer_cityname ON customer(cityname);

-- insert a sample record:

INSERT INTO customer VALUES(1, 'Billy', 'Smith', 'Summerset Drv', '1001',

'123456789', 'Littleton', 'US', '555-1234', '1950-12-01');

-- to be able to use stopwords a stopword table is needed:

CREATE COLUMN TABLE stopwords

(

stopword_id VARCHAR(32) PRIMARY KEY,

list_id VARCHAR(32) NOT NULL,

language_code VARCHAR(2),

term NVARCHAR(200) NOT NULL

);

GRANT SELECT ON stopwords TO _sys_repo WITH GRANT OPTION;

INSERT INTO stopwords VALUES('1', 'firstname', '', 'Dr');

-- and for term mappings another table:

CREATE COLUMN TABLE termmappings

(

mapping_id VARCHAR(32) PRIMARY KEY,

list_id VARCHAR(32) NOT NULL,

language_code VARCHAR(2),

term_1 NVARCHAR(255) NOT NULL,

term_2 NVARCHAR(255) NOT NULL,

weight DECIMAL NOT NULL

);

GRANT SELECT ON termmappings TO _sys_repo WITH GRANT OPTION;

INSERT INTO termmappings VALUES('1', 'firstname', '', 'William', 'Will',

'1.0');

INSERT INTO termmappings VALUES('2', 'firstname', '', 'William', 'Bill',

'0.9');

INSERT INTO termmappings VALUES('3', 'firstname', '', 'William', 'Billy',

'0.9');

INSERT INTO termmappings VALUES('7', 'firstname', '', 'Will', 'William',

'1.0');

INSERT INTO termmappings VALUES('8', 'firstname', '', 'Will', 'Bill',

'0.9');

INSERT INTO termmappings VALUES('9', 'firstname', '', 'Will', 'Billy',

'0.9');

218

PUBLIC

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

INSERT INTO termmappings VALUES('4', 'firstname', '', 'Bill', 'William',

'0.9');

INSERT INTO termmappings VALUES('5', 'firstname', '', 'Bill', 'Will',

'0.9');

INSERT INTO termmappings VALUES('6', 'firstname', '', 'Bill', 'Billy',

'1.0');

4.3.4.12.8.4 Defining the Attribute View

As the user MODELOWNER, you create the attribute view that is used for the search.

Context

The attribute view is created in the SAP HANA Systems view that is part of the SAP HANA studio (either in the

Modeler perspective or in the SAP HANA Development perspective).

Procedure

1. In the package 'apps.customer', create a new attribute view called CUSTOMER (containing all columns

from table CUSTOMERS.CUSTOMER).

2. Save and activate the attribute view.

A SELECT privilege is required for a user to see the contents of the activated attribute view.

-- allow users MODELOWNER and APPOWNER to see the contents of the attribute

view

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

PUBLIC

219

CALL GRANT_PRIVILEGE_ON_ACTIVATED_CONTENT('SELECT',

'"apps.customer::CUSTOMER"', 'MODELOWNER');

CALL GRANT_PRIVILEGE_ON_ACTIVATED_CONTENT('SELECT',

'"apps.customer::CUSTOMER"', 'APPOWNER');

The contents of the view are now visible to users MODELOWNER and APPOWNER.

-- test the view

SELECT * FROM "apps.customer::CUSTOMER";

4.3.4.12.8.5 Creating the Search Rule Set

Read about the steps needed to define a search rule set and to run the final application.

Procedure

1. Preparing the Development Environment

The SAP HANA studio is used to create, modify, and activate search rule sets.

Before creating your first search rule set, you have to set up a native SAP HANA Development project in

the SAP HANA studio:

1. Open the SAP HANA Development perspective.

2. Create a new repository workspace in the SAP HANA Repositories view.

Use the database connection of user MODELOWNER for the repository workspace.

3. Create a new project called 'project' in package 'apps.customer'.

○ Select 'General/Project' for a project that contains search rule sets only.

○ Select 'SAP HANA Development/XS Project' for native SAP HANA projects.

○ Use 'Team/Share Project' to move the project to the repository package 'apps.customer'.

2. Defining the Search Rule Set

The next step for user MODELOWNER is to define the search rule set that will be used by the application.

This is done in the Project Explorer view in the SAP HANA studio.

The steps to define the search rule set are as follows:

1. In your project, create a new search rule set 'Search.searchruleset'.

The search rule set is created in the package 'apps.customer.project'.

2. Edit the search rule set.

○ Define view "apps.customer::CUSTOMER" as the view that will be searched.

○ Define at least one rule (for example, use columns FIRSTNAME and LASTNAME in the rule).

3. Save the search rule set.

4. Commit and activate your changes.

Now you can call the search in the SAP HANA studio:

-- run the search

CALL SYS.EXECUTE_SEARCH_RULE_SET('

220

PUBLIC

SAP HANA Search Developer Guide

Accessing Data Using Full-Text Search

Documents you may be interested

pdf to tiff conversion c# : .Net read pdf text software application dll winforms html .net web forms SAP_HANA_Search_Developer_Guide_en21-part202