Tag: operator
-
Post Views: 15 1. Request parameter: filter[and][0][or][0][title][like]=\, the generated sql is as follows, the search result is empty. as shown in Figure 1 2. Check the value of the field title in the table plan, one of the records exists \. In theory, it is possible to query a record. as shown in Figure 2 3. Execute SQL in Navicat…
-
Post Views: 18 1. Expect the generated SQL statement, as shown in Figure 1 2. LIKE: The first operand should be a field name or dB expression, and the second operand can make a string or an array, representing the value of the first operand that needs to be fuzzy. For example,[‘like’, ‘name’, ‘tester’]will generate name like%tester%. If the range…
-
Post Views: 15 1. In Postman, open the URL:http://api.pcs-api.localhost/v1/plan-config-column-users?login_id=2e368664c41b8bf511bcc9c65d86dbc3&login_tid=685f805f71faedfe215f55bbb01b50c6&filter[config_column_id]=1 , only the fields are supported: config_column_id queries, the response is as follows: 2. The SQL statement is as follows: 3. Existing new requirements need to support the fuzzy query of user_nick, but the field: user_nick does not exist in mysql ActiveRecord, but exists in Redis ActiveRecord. And Redis ActiveRecord does…