neo4j - Cypher query with ORDER BY on translation with fallback -


i have following data model:

  • node entity businessobject
  • node entity translation containing language , text property
  • relationship translates translation business object, potentially multiple

the translations allow me present texts appropriate users language. example, user able read german, business object translated english , german, ui displays german. in general, there's fallback user's language default language (english).

now, query businessobjects , order them translation should include fallback. possible cypher?

edit: example

businessobject a translations ("en", "xyz english translation a") , ("de", "deutsche Übersetzung für a").

businessobject b translations ("en", "some english translation b") , ("fr", "traduction français pour b").

a user u1 has language german ("de") , fallback should english ("en"). so, querying business objects should result in list [a, b] because translation "deutsch... für a" before "some en...for b" lexicographically when ordering ascending. on other hand, when second user u2 has language french, result should [b, a] because "traduc... pour b" before "xyz eng... a". third english user u3 should result [b, a] because translation "some... b" before "xyz... a".

so need ordering done database if possible.

edit: solution

with great ideas answers, came following query:

match (r:businessobject) r optional match (r)<-[translates]-(t:translation) t.language = 'de' // user language r, t.text t1 optional match (r)<-[translates]-(t:translation) t.language = 'en' // fallback r, coalesce(t1, t.text) sort return distinct r order sort;

surely, hasn't best performance that's ok me. contributers!

i don't know way set order by that. short of finding answer if exists, option might return fallback separately.

with "english" fallback  match (b: businessobject)-[:translates]-(fbtr: translation) translation.language = fallback fallback, fbtr, b match (b)-[:translates]-(tr: translation) translation.language <> fallback return collect(tr) translations, fbtr fallback

edit
here's simpler idea sorts language, putting fallback last:

with 'english' fallback match (b:businessobject)-[:translates]-(t) t, case t.language     when fallback -1    else 0 end sort return t order sort desc, t.language

maybe closer you're looking for.


Comments

Post a Comment

Popular posts from this blog

node.js - Node js - Trying to send POST request, but it is not loading javascript content -

i have been trying send post request website, , has not been loading full site. i guessing problem node js not loading javascript content, executing it. can see javascript in response, though never loads content javascript files producing in html. what mean is, doesn't execute javascript. how make node js code overcome this, , wait the full website load? have tried native code, , "request' module, both producing same errors. if helps, don't need native javascript. modules fine. some code have tried (request module): var options = { method: 'post', uri: 'https://url', formdata: { 'email': 'email', 'prize': '0', 'transactional': 'on' }, headers: { /* 'content-type': 'application/x-www-form-urlencoded' */ // set automatically } }; rp(options) .then(function (body) { console.log(body) }) .catch(function (err) { console.log(err) }); when fetch content...
Read more

javascript - Replicate keyboard event with html button -

i have tried few ways make happen. have javascript pinball game uses keyboard keys controls. converting application touch screen display. workaround, hoping overlay buttons when clicked simulate keyboard strokes. have done research , sounds should work. using jquery v3.2.1 here things have tried far... html element: <input type="button" class="coil"></input> $('.coil').trigger({type: 'keydown', which: 40, keycode: 40}); with this, not errors, nothing happens. var coilkey = $('body').keydown(function(e) { switch (e.keycode) { case 40: break;} }) $('.coil').click(coilkey); this 1 returns error in console... ((jquery.event.special[handleobj.origtype] || (intermediate value)).handle || handleobj.handler).apply not function below javascript game engine handles key listeners... addkeylistener: function (keyandlistener) { this.keylisteners.push(keyandlistener); }, // gi...
Read more

javascript - Web audio api 5.1 surround example not working in firefox -

i've been playing lott lately web audio api on both firefox , chrome. few days ago started experiment surround set. when trying surround audio in web audio api came notice example works fine in chrome v59 not in firefox v54. // create web audio api context var audioctx = new (window.audiocontext || window.webkitaudiocontext)(); audioctx.destination.channelinterpretation = 'discrete'; audioctx.destination.channelcountmode = 'explicit'; audioctx.destination.channelcount = 6; var oscillators = []; var merger = audioctx.createchannelmerger(6); console.log(audioctx.destination, merger); //merger.channelinterpretation = 'discrete'; //merger.channelcountmode = 'explicit'; //merger.channelcount = 6; var addoscilator = function(channel, frequency) { var oscillator = audioctx.createoscillator(); oscillator.frequency.value = frequency; // value in hertz oscillator.connect(merger,0,channel); oscillator.start(); oscillators.push(o...
Read more