Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How To Implement SQL Dynamic In DataManager

Status
Not open for further replies.
SPI33

SPI33

Programmer
Oct 5, 2005
11
FR
User Need :
We wish to set the extraction of data from a table based on filter statements expressed by an administrator in a flat file.
Constraints :
The number of filter statements is not fixed. There is at least one filter statement.
The format of this flat file is fixed.
Flat file filter format : FilterName;FilterNumber;FilterStatement x
Examples :
Customer ID;1;Customer_ID>1000
Customer Country;2;Cust_Country=India

Question :
How to implement these Filter Statements in the DataSourceProperties Query

 
Status
Not open for further replies.

Similar threads

beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
181
beegeeblueboy
beegeeblueboy
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
141
deborahyr63
deborahyr63
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
170
tushargaurav
tushargaurav
sreevp2020
  • Locked
  • Question
dynamic deafult date in date prompt calandar
Replies
0
Views
154
sreevp2020
sreevp2020
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
149
wwconslt
wwconslt

Part and Inventory Search

Sponsor

Back
Top