- Lynne Harding
- Posts : 335
Join date : 2018-12-20
Change filter on a searchlist button
Mon 30 Mar 2020 - 7:54
We have a button on the search list that shows all Live matters. The action is ViewActive and this is the paramater that it uses
< config > < trashCan fieldname=“FileStatus” changeValue=“LIVE*” /> </ config >
Is it possible to have more than one paramater, so when the button is clicked it will show matters with a status of LIVE and PARTOPENED. If yes what is the syntax for this?
< config > < trashCan fieldname=“FileStatus” changeValue=“LIVE*” /> </ config >
Is it possible to have more than one paramater, so when the button is clicked it will show matters with a status of LIVE and PARTOPENED. If yes what is the syntax for this?
- Lynne Harding
- Posts : 335
Join date : 2018-12-20
Re: Change filter on a searchlist button
Mon 30 Mar 2020 - 7:54
The active filter only applies to a single field if you add a % symbol to the changevalue then a 'like' will be performed instead of an equals but that won't help in your case.
You could overcome the limitation in your query that returns the data by computing a column value.
select
*, CASE WHEN fileStatus like 'LIVE%' THEN 1 WHEN fileStatus = 'PARTOPENED' THEN 1 ELSE 0 END AS IsLive from dbfile And set fieldName = IsLive and changeValue = 1
You could overcome the limitation in your query that returns the data by computing a column value.
select
*, CASE WHEN fileStatus like 'LIVE%' THEN 1 WHEN fileStatus = 'PARTOPENED' THEN 1 ELSE 0 END AS IsLive from dbfile And set fieldName = IsLive and changeValue = 1
- Lynne Harding
- Posts : 335
Join date : 2018-12-20
Re: Change filter on a searchlist button
Mon 30 Mar 2020 - 7:55
How about changing the code for PARTOPENED to LIVEPARTOPENED?I think all of our queries look for a prefix of LIVE when displaying live matters.
Permissions in this forum:
You cannot reply to topics in this forum
|
|