I'm curious how much SQL is supported in Dateband Filter expressions. It seems to be supported partially, but limited. I would like to use the IN and LIKE operators, with wildcard characters as in the following expression: tablename.fieldname IN ("AA","BB","CC") AND NOT tablename.fieldname LIKE "%RR%"
Any suggestions?
SQL in Filter expression
SQL in Filter expression
Hello.
There are no SQL queries in filers in Data Bands. They are processing all incoming data for a condition in situ using C#/VB syntax.
Thank you.
SQL queries is used only in Data Sources.djm000111 wrote:I'm curious how much SQL is supported in Dateband Filter expressions. It seems to be supported partially, but limited. I would like to use the IN and LIKE operators, with wildcard characters as in the following expression: tablename.fieldname IN ("AA","BB","CC") AND NOT tablename.fieldname LIKE "%RR%"
There are no SQL queries in filers in Data Bands. They are processing all incoming data for a condition in situ using C#/VB syntax.
Thank you.
SQL in Filter expression
Would you mind giving me more information about the sentence: "They are processing all incoming data for a condition in situ using C#/VB syntax." I assume you are talking about the filters. Are you suggesting that writing a function in VB would extend the capabilities of the filters? Would it be practical for me to write a VB function using SQL to return a filter string?
SQL in Filter expression
Hello.
Maybe you want to set the filter using data from SQL query.
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?
Thank you.
I meant that Data Band receives all data from Data Source and displays only data which is matching the condition of filter.djm000111 wrote:Would you mind giving me more information about the sentence: "They are processing all incoming data for a condition in situ using C#/VB syntax." I assume you are talking about the filters. Are you suggesting that writing a function in VB would extend the capabilities of the filters? Would it be practical for me to write a VB function using SQL to return a filter string?
Maybe you want to set the filter using data from SQL query.
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?
Thank you.
SQL in Filter expression
HighAley, thank you for your reply. Here is more explanation about what I would like to do.
I would like to create a VB function that contains a SQL statement that returns a dataset containing just the information needed.
If it is not possible using a VB function, would you tell me why?
Also, if it is not possible using a VB function, how can I set the filter using data from SQL query?
Thank you.
I would like to create a VB function that contains a SQL statement that returns a dataset containing just the information needed.
If it is not possible using a VB function, would you tell me why?
Also, if it is not possible using a VB function, how can I set the filter using data from SQL query?
Thank you.
SQL in Filter expression
Hello.
Thank you.
As we understand you can use SQL query in your Data Source.djm000111 wrote:I would like to create a VB function that contains a SQL statement that returns a dataset containing just the information needed.
If it is not possible using a VB function, would you tell me why?
Also, if it is not possible using a VB function, how can I set the filter using data from SQL query?
Thank you.
SQL in Filter expression
Thank you for your patience.
SQL in Filter expression
Hello,
Let us know if you have additional questions.
Thank you.
Let us know if you have additional questions.
Thank you.