Maximo Open Forum

 View Only

Is it not possible to query data sources using the WHERE clause on mobile devices using the Maximo mobile app?

  • 1.  Is it not possible to query data sources using the WHERE clause on mobile devices using the Maximo mobile app?

    Posted 2 hours ago

    Hello.

    I am currently developing the Maximo mobile app (MAF App).

    I created the page controller and executed the relevant method, but it seems that the query is not working with the WHERE clause.

    The functionality I want is to retrieve both the fromdate and todate for the 'tagstartdate' column in a single query to retrieve data between the fromdate and todate.

    It appears that using setqbe only satisfies one of the two conditions: querying by fromdate or querying by todate. I would appreciate your suggestions on how to resolve this.

    Also, could you explain how the web and mobile differ so that a feature that works on the web does not work on mobile devices?

    Thank you.

    ------------------------------------

       async testWorkSearch(e){
            const fromdate = this.dateFormat(new Date());
            const todate = this.dateFormat(new Date());

            const dateWhere = `targetstartdate>="${fromdate}" and targetstartdate<="${todate}"`;

            await this.listDS.load({
                noCache: true,
                where: dateWhere
            });
        }


    #MaximoApplicationSuite

    ------------------------------
    GeunYoung Ahn
    Visionic
    ------------------------------