Hi
I need to make a query in QAAWS with Like… But I did not find any matching keywork…
I have a date column which has 24 rows of data for a day… How can i pass a date and bring all the rows for that data.
for example… date like ‘09-NOV-11’ which will return me 24 rows… if i say date = ‘09-NOV-11’ it is coming back with only one row…
Thanks…
rajx72 (BOB member since 2006-08-02)
I use “matches pattern”, which verifiably works against Oracle or SQL Server databases.
Cairmor 
(BOB member since 2008-06-05)
Hi
I did not see that option in QAAWS… that is available in WEBI… but what can i use in QAAWS…
Thanks…
rajx72 (BOB member since 2006-08-02)
I believe your database determines what operators are in QaaWS. One of them has to be close to Like. Here is an example of Matches Pattern in QaaWS:
Cairmor (BOB member since 2008-06-05)
HI
We are using Oracle 11g… as our database… and in QAAWS besides… greater than , less than and not inlist, null… i see Both and Expect…and I am using Xcelsius 2008.
Thanks
rajx72 (BOB member since 2006-08-02)
I dont know why your operator list is different. Ive worked on alot of oracle sources and never had a problem with MatchesPattern.
However, for a workaround…since you are looking for a date range…did you try using two prompts ? Both random date values could be bound to the same cell.
A) BETWEEN ‘09-NOV-11’ AND ‘09-NOV-11’
or
B) 1st prompt is >= ‘09-NOV-11’ 00:00:00 2nd prompt is <=‘09-NOV-11’ 23:59:59
something like that…
Cairmor (BOB member since 2008-06-05)
HI
MY dba change the view… now if i run the query using “=” i am getting the data…
but I ran into one more issue… I have a date column on which i am making a prompt…in QAAWS… and passing the value from dashboard…
so when i run the query in QAAWS, it shows me a calender and when i select the date it says Date= 11/9/11 12:00:00 AM. and show me the result.
But when i am passing the date in same format from dashboard… i am not getting any data…
any idea guys…
Thanks
rajx72 (BOB member since 2006-08-02)
Hi, how would I achieve a one sided wildcard search in QaaWs? For example, I wish to return a list of all users whose names begin with A. In SQL I would use like ‘A%’.
I can’t see how to do this in QaaWS.
Thanks
Phil
philtench (BOB member since 2011-01-27)
Hi
in Qaaws say “objectname” Matches Pattren A%… it will show all the names stating with A… then make this as a prompt… and in dashboard add % to the the destination cell… say in A1 you have “A” then in B1 type “%” then then in C1 = A1&B1 and pass C1 to the prompt
Thanks
rajx72 (BOB member since 2006-08-02)
That worked perfectly, may I convey much gratitutude for your help. 
philtench (BOB member since 2011-01-27)