Transform x-path API filter to query builder APi filter
4️⃣v4
We want to replace our current system with a filament app.
The API in the current system is using as filter an x-path logic using and/or blocks and different operators >=, <=, >, <, = , != and date operators
I'm investigating if a middleware or parser can be build to transform the x-path filter to internal API allowedFilters
Some examples:
(date-greater-or-equal(./metaData/mostRecentUpdate,'2020-11-01T00:00:00.000')) and (date-less-or-equal(./metaData/mostRecentUpdate,'2020-11-10T23:59:59.000'))
./listTypeId='4'and./msfEntityId='5'
./id=21334
./familyName='EXO' or ./familyName='DIS'
./familyId='DEXO'
./familyId='DEXO' or ./familyName='TOY'
./groupId='D' or ./groupCode='E'
I also need to map the x-path parts to internal fields values and for some of them fields from relations are needed
as example for mapping: ./familyName would be the name field from relation family defined on our Model.
I wonder if somebody has some pointers/documentation I can read as guidance?
Is there maybe a plugin/library that can help in transforming the x-path?
The API in the current system is using as filter an x-path logic using and/or blocks and different operators >=, <=, >, <, = , != and date operators
I'm investigating if a middleware or parser can be build to transform the x-path filter to internal API allowedFilters
Some examples:
(date-greater-or-equal(./metaData/mostRecentUpdate,'2020-11-01T00:00:00.000')) and (date-less-or-equal(./metaData/mostRecentUpdate,'2020-11-10T23:59:59.000'))
./listTypeId='4'and./msfEntityId='5'
./id=21334
./familyName='EXO' or ./familyName='DIS'
./familyId='DEXO'
./familyId='DEXO' or ./familyName='TOY'
./groupId='D' or ./groupCode='E'
I also need to map the x-path parts to internal fields values and for some of them fields from relations are needed
as example for mapping: ./familyName would be the name field from relation family defined on our Model.
I wonder if somebody has some pointers/documentation I can read as guidance?
Is there maybe a plugin/library that can help in transforming the x-path?
