Re: [db-wg] fulltextsearch question

[Hank Nussbacher via db-wg]

On 18/06/2021 08:36, Hank Nussbacher wrote: As I delve deeper I am more confused.  I went to: https://www.ripe.net/manage-ips-and-asns/db/support/querying-the-ripe-database#4--query-multiple-databases-with-the-global-resource-service and wanted to search not just RIPE but all RIRs.  So I started with a simple search like: https://apps.db.ripe.net/db-web-ui/query?bflag=true&dflag=false&rflag=true&searchtext=marlink&source=RIPE&types=organisation 1 hit. Very nice.  Easy peasy. So I now try all RIRs: https://apps.db.ripe.net/db-web-ui/query?bflag=true&dflag=false&rflag=true&searchtext=marlink&source=GRS&types=organisation No hits.  Shouldn't I have had at least 1 hit from RIPE for this search? Regards, Hank On 18/06/2021 00:38, Edward Shryane wrote: This helps as a start.  I had played with standard search: http://rest.db.ripe.net/search?type-filter=inetnum&query-string=TEST but as per the documentation in github: https://github.com/RIPE-NCC/whois/wiki/WHOIS-REST-API-search with: type-filter     Optional. If specified the results will be filtered by object-type, multiple type-filters can be specified. doesn't seem to work since I am getting object-types other than inetnum (such as role or person).  Unless I am doing something wrong.  Can you clue me in to the proper syntax?  Will type-filter=inetnum work on fulltextsearch as well? Incidentally, the first and second examples on that RIPE github page: http://rest.db.ripe.net/search?inverse-attribute=org&type-filter=inetnum&source=ripe&query-string=ORG-NCC1-RIPE results in: ERROR:101: no entries found No entries found in source %s. Seems like source=ripe is causing issues. Thanks, Hank Hi Hank, The webpage is restricted to a maximum of 10 pages with 10 matches on each page, but if you don't mind reading XML or JSON you can make the call directly: XML: https://apps.db.ripe.net/db-web-ui/api/rest/fulltextsearch/select?facet=true&hl=true&q=(TEST)&start=0&rows=800 JSON: https://apps.db.ripe.net/db-web-ui/api/rest/fulltextsearch/select.json?facet=true&hl=true&q=(TEST)&start=0&rows=100 In this example I'm searching for "TEST". Add a "rows" query parameter to limit matches, and ".json" to the end of the path to specify a JSON response. The upcoming Whois 1.101 release exposes this API directly via https://rest.db.ripe.net/ and we will document it fully. Also we plan to improve the query page in the coming months, we will look at integrating full text search and allowing more results. Regards Ed Shryane RIPE NCC On 17 Jun 2021, at 18:45, Hank Nussbacher via db-wg <db-wg@ripe.net> wrote: I am using https://apps.db.ripe.net/db-web-ui/fulltextsearch to do a full text search to return just the inetnum record but if I get 800 hits I get only 10 entries per screen. How can I see all 800 hits at once? Thanks for any clue provided. Regards, Hank