[Pierre-Luc]

I would like to use the filter in the URL link.

I have 5 records with 2 fields (Color and Shape)

Record 1 (Color = Blue, Shape = Square)
Record 2 (Color = Red, Shape = Round)
Record 3 (Color = Yellow, Shape = Triangle)
Record 4 (Color = Pink, Shape = Diamond)
Record 5 (Color = Red, Shape = Square)

I would like to display the Reds and Squares simultaneously, so records 1, 2 and 5.

If I use this URL:
http: //ipaddress/sosimple/sosimple_cal.php?calendar=1-2-XXXXXXXXX&Color=Red&Shape=Square#date=2018-03-15,mode=week
SoSimple only shows me “Square” records

If I use this URL:
http: //ipaddress/sosimple/sosimple_cal.php?calendar=1-2-XXXXXXXXX&Shape=Square&Color=Red#date=2018-03-15,mode=week
SoSimple only shows me “Red” records

Where is my mistake ?

[adminKeymaster]

Hi Pierre –

Are you using a current version of soSIMPLE? The results shouldn’t depend on the order of the parameters. Both of your examples should result in only Record 5 showing. (red AND square).

“OR” type requests can be done on single fields (color = red OR blue) but not across multiple fields. That would require an advanced server-side script.

[Pierre-Luc]

Hello,

I am using version 3.31.

I used the “advenced server-sied script” and global field in the “find_parameter=” which are then filtered.

Everything works fine.

Thank you

[adminKeymaster]

Nice work.

Version 3.5 addressed URL filtering – fixed the issue you saw with the order of search parameters, and added more complex “or” operations.

https://www.sosimplesoftware.com/products/calendar-documentation/change-log/

[Author]

Posts