TableRequestInfo.UserFilter for .NET RO/DA server

Data Abstract
1

How do you use TableRequestInfo.UserFilter for a .NET RO/DA service?

Putting SQL in there does not do anything.

Documentation states it is disabled by default
(TableRequest Object)

Our delphi code sets service.AllowuWhereSql to true to use this but this property is not available in our .NET RO version.
I have tried AllowDynamicWhere but this does not do anything.

I have tried tableRequestInfoV7.WhereClause but this gives an errors
The tableRequestInfoV5.WhereClause has type XmlNode which I do not know how to create

Searching for SetWhereClause on docs.dataabstract.com yields me no useable info

2

Hi,

UserFilter feature was replaced with Dynamic Where.

I can suggest to review Dynamic Where sample - it shows how to use Dynamic Where.

What error do you have?

WhereExpression lCondition = 
	new BinaryExpression(
		new FieldExpression("Role"),
		new ConstantExpression("%Manager%", DataType.String),
		BinaryOperator.Like
	);
lRequestInfo.WhereClause = lCondition.ToXmlNode();
3

  1. For V7 it was some kind of (xml) parsing error. For V7 the WhereClause property is of type string. I passed raw SQL to it. This failed. How is the WhereClause property interpreted for V7?

  2. The method of creating an XML and putting it in the WhereClause (V7) works

  3. Can you however still explain how raw SQL works for .NET DA service (i won’t be using it now but maybe the need comes in the future)

  4. What is the function of the UserFilter field? It is still in the documentation online

4

p.s. Do I need AllowDynamicWhere?
The documentation does not tell me much

image
image796×215 5.68 KB

5

Hi,

it is XML based string.

server-side can read both formats (JSON- and XML-based string)

DAN doesn’t support raw SQL unless you are using SQL* methods. they are still supported for backward compatibility with DA4.

by other hand, you can use raw SQL in DA SQL

this is atavism for backward compatibility with DA4.

yes, you need it if Dynamic Where is used.