Can you perform a search that is executed on the server and returns only matching values in Rollbase mobile? - Forum - Mobile - Progress Community

Can you perform a search that is executed on the server and returns only matching values in Rollbase mobile?

 Forum

Can you perform a search that is executed on the server and returns only matching values in Rollbase mobile?

This question is not answered

I am building a mobile app and need the ability to search for certain values to limit the amount data being returned to the device.  I know I can use a list item and data filter to limit records on the client side, but I really need to be able to submit a value, like a name, and have it return only records matching that name.

Is this possible today?

Thank you in advance for your time.

All Replies
  • Hello,

    Did you check this document explaining how to do a search in a Rollbase Mobile App? https://community.progress.com/.../971.aspx.


    Thank you,

    Gian

  • HI Gian,

    I have used the data filter before which in this case, I believe, is just filtering the records in your list that are returned by your view.  When I ran through an example like that, I wasn't able to filter items that didn't show up on my first page, so the end user could not find the record they are looking for.  If I leave the rows per page value blank, it doesn't appear to bring back all my records anyway, which is good.  In this case, I am talking about 50,000 records that I need to be able to search through and return values by name.

    In my example below, I set the rows per page to 3.  I have an account that returns on this list called AA Maintenance.  If I try and use the data filter from the list, I cannot get the value to return, because it wasn't one of the first 3.

  • Hello,

    I see. I think you are right about the data filter search being a client side process only. Let me get back to you while I check if the server side search functionality already exist in the current Rollbase Mobile version.

    Thanks,

    Gian

  • Thanks Gian,

    This app is running on 3.0.2, so if there is something in a newer version, please let me know.

  • Any luck on this Gian?  It is a huge issue for us and could be a show stopper with our current client as well as future clients if we can't perform a server side search.  We just can't take the performance hit of returning all these values when the dataset is so large.

  • Any thoughts on this one?  I really need to know if there is a way for me to hit an API in Rollbase from a mobile device that will allow me to search on the server rather than return all records.  This is a potential show stopper for my client.  Any response is appreciated.

    Thanks,

    Jason

  • Hi jsniemi79,
     
    In theory, this is possible using the selectQuery API provided by Rollbase. We can create a REST service in Mobile App Builder environment using the selectQuery API and appending the valid session (as mobile requires a valid session attribute to make REST call to Rollbase) in the REST call might do the trick (this method will perform the server side search). I haven’t tried this approach.
     
    Hope this helps.
     
    Thanks and Regards,
    Anil Kumar.
     
    From: jsniemi79 [mailto:bounce-jsniemi79@community.progress.com]
    Sent: Friday, November 14, 2014 9:16 PM
    To: TU.Mobile@community.progress.com
    Subject: RE: [Technical Users - Mobile] Can you perform a search that is executed on the server and returns only matching values in Rollbase mobile?
     
    Reply by jsniemi79

    Any thoughts on this one?  I really need to know if there is a way for me to hit an API in Rollbase from a mobile device that will allow me to search on the server rather than return all records.  This is a potential show stopper for my client.  Any response is appreciated.

    Thanks,

    Jason

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

  • Hi Anil,

    Can you give me some direction on where to get started to try this?  I'm not a developer, so this is a little new to me.

    Thanks,

    Jason

  • How do you append the session ID to the service?

    I've got the selectQuery service created and can run a test which is returning accurate results.  I pulled a RSessionID from Fiddler to test, but I don't know how to get that same value to pass to my query.