Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi to all ,
i need to set compicate filter on my model , I have BlackID and ID_DATE ,
The supose to be like that :
SHOW ALL BigID's WITH ( ( BlackID = 6 and ID_DATE >= 01/01/1992 ) or ( BlackID = 42 and ID_DATE >= 01/01/1992 ) )
is there any way to set it on list-box advance search , or as bookmark , or any other way ?
THANKS!!
how can i do it , dont see in edit the option.
Use Set Analysis
Count({<BlackID = {6} ,ID_DATE = {">= 01/01/1992"} >} BigID)
or
Count(if(BlackID=6 and ID_DATE >= 01/01/1992, BigID))
hi Vineeth , i need to filter all model , so the population will be according to the condition .
do you mean in the load script?
Hi Yaniv,
I think the value 6,42 and date are something that you should be able to select in filter.??
If the user selects multiple BlackIDs you need the union of data of all the blackIDs.??
If Yes, Maybe you can use filters for BlackID and Id_Date and write set analysis to get the data, like Vineet mentioned something like Count({<ID_DATE = {">= $(=Max(Id_Date ))"} >} BigID). This will get the data of all the blackIDs selected and for each blackId it will check if the date is greater than or equal to the Id_Date selected in the filter.
Another solution could be
You can create one button on which you can set the action to select all the BigIDs
Button->Action->Add->Select in field
Field -> BigID
Search string->
='( '& Concat( distinct if(((BlackID = 6 and floor(ID_DATE) >= floor(date#('01/01/1992','DD/MM/YYYY')) or ( BlackID = 42 and floor(ID_DATE) >= floor(date#('01/01/1992','DD/MM/YYYY')),chr(34)&BigID&chr(34)),'|') & ')'
On clicking of this button all the BigIds will get selected
Are you looking to select a particular row which meets the condition or if one of the row meets the condition, you will select the whole BigID? If you are looking to select a particular row, I think you will need to have a unique identifier.
Would you be able to share a qvw with your expected output?
hi to all , i solved the problem in the DB level , thanks !!
Nice Please close the thread.
how can i do it , dont see in edit the option.