• Home>
• Guide>
• Induct query language (IQL)

Induct query language (IQL)

The Induct query language lets you retrieve a specific result set.

IQL follows the pattern in the examples below. View the API and object listings to predict what other fields can be used to filter and order on.

Example queries

Initiatives

Get all ideas with innovation type = 2

https://api.induct.no/v1/3hwetj35yhb/initiatives/ideas/?q=where innovationtype=2

Get all ideas created by user having id = 3, order ideas by date created

https://api.induct.no/v1/3hwetj35yhb/initiatives/ideas/?q=where createdby=3 order by createdat

Get all ideas with status = 2 and innovationtype = 92 order by popularity of idea descending (Most popular on top)

https://api.induct.no/v1/3hwetj35yhb/initiatives/ideas/?q=where where status=2 and innovationtype=92 order by popularity desc

Get all challenges having title containing the word test

https://api.induct.no/v1/3hwetj35yhb/initiatives/challenges/?q=where title like 'test'

Get all public ideas having status=1 and title or description containing the word test

https://api.induct.no/v1/3hwetj35yhb/initiatives/ideas/?q=where+accessrestriction.listaccess=anonymous and status=1 and (title like 'test' or description like 'test')

Get all ideas for focusarea 442 using paging (start at row 10 and return up to 5 items)

https://api.induct.no/v1/3hwetj35yhb/initiatives/ideas/?limit=5&offset=10&q=where focusarea = 442

Users

Get user having username user@domain.com

https://api.induct.no/v1/3hwetj35yhb/users/?q=where username="user@domain.com"