Search across multiple columns (or instead of and)

Posts about the simPRO API. Help/support/how-to etc.
Forum rules
  • Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
  • No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
  • Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
  • Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
  • Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
  • Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
  • Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
  • Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
Post Reply
zzbots
Posts: 6
Joined: Thu Apr 18, 2019 4:41 am

Search across multiple columns (or instead of and)

Post by zzbots » Tue Jun 11, 2019 1:06 am

Hi,

I'm wondering if there is a way to search multiple columns simultaneously and receive items with any matching columns instead of only items where all columns match? So for example, if I want to search both Name & PartNo columns for the wildcard %25Bracket%25 and receive items where the word Bracket appears in either Name or PartNo?

I know this could be done with multiple queries, but if there is a way to achieve this in a single query I would love to know.

Thanks
Top
Muqeet
Posts: 772
Joined: Mon Dec 03, 2018 3:24 am

Re: Search across multiple columns (or instead of and)

Post by Muqeet » Wed Jun 12, 2019 12:54 am

Hi,

Currently there is no way in the API to get resources based on the criteria you mentioned, the more fields you define, it will basically just start to filter results for you instead of responding with all possible matches.

Thanks.
Muqeet
Muqeet
API Developer | simPRO Software Group
Top
zzbots
Posts: 6
Joined: Thu Apr 18, 2019 4:41 am

Re: Search across multiple columns (or instead of and)

Post by zzbots » Wed Jun 12, 2019 2:15 pm

Does the API have an endpoint for batch requests, or if not would that be a feasible addition? I noticed the /multiple for post and patch requests... it would be awesome if something like that was an option for get requests.
Top
rick.lan
Posts: 274
Joined: Wed May 30, 2018 6:14 am

Re: Search across multiple columns (or instead of and)

Post by rick.lan » Tue Jul 02, 2019 3:14 am

Hi zzbots,

Thank you for your message, unfortunately we do not have any plan to implement search multiple/batch feature at the moment, however, we will look into it in the near future if we have many developers request for it.

cheers,

Rick
Rick Lan
API Developer | simPRO Software Group
Top
Post Reply

Return to “General Discussion”