Using query option in url to find records

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

I want to have sql query to select some data using where option ?
I must use it like api.
For example I want to have there sql query( select * from accounts where City = ‘London’

After substitution it transformed to http://10.224.0.30/suitecrm/index.php?action=index&module=Accounts&searchFormTab=advanced_search&query=select%20*%20from%20account%20where%20city%20=%20’London’
But it doesn’t work.

What i should do to change in url ?

2

you should use the search field that is available in the Filter, something like

index.php?action=index&module=Accounts&searchFormTab=advanced_search&query=true&address_city_advanced=London

3

@cherub-chum hi

I have the same question how to get a ULR link with pre-filtered data
For example, I wanna filter this column
image

and URL looks like this
/index.php?action=index&module=my_module&searchFormTab=advanced_search&query=true&status=open

unfortunetly it doesnt any effect
Maybe I did something wrong?

Thanks

4

can you try with status_advanced=open

1 Like
5

very thank you for explain
It’s work
Also for access to the custom field I try status_c_advanced=open

6

Hi @cherub-chum

Please can you help me another time
Is it possible to do many parameters filter?
For example, I have status: Open, In Review
I’m trying to do URL like /index.php?action=index&module=my_module&searchFormTab=advanced_search&query=true&status_advanced=open&InReview
but it doesn’t work

7

Hi,

The following query will do the trick(getting accounts with a name of test)

http://10.224.0.30/suitecrm/index.php?action=index&module=Accounts&searchFormTab=advanced_search&query=true&clear_query=true&name_advanced=test

8

yes, it’s work
but how I can get a filter with two more parameters?
example name_advanced=test,test1,test2,test3 ?

How does it’s look in SuiteCRM interface:
image
but how I can pass it on URL?